| Thread | Last Post | Replies |
|
| Filtering in Access 97 | 19 Mar 2007 04:07 GMT | 4 |
I was wondering if some kind person could answer this question for me or give me a leader in help for it. I have to filter out from a database all the Client codes from a field that looks like this
|
| Setting a Criterion (Criteria) In a Query... | 19 Mar 2007 03:06 GMT | 2 |
Such as....Forms!frmMain!ForLast ...to be used in a Query.... If I use a Dropdown to select something like "R - Z" and then populate an unbound Field named "ForLast"
|
| I just loaded Office 2000 on Vista Business. I need help. | 19 Mar 2007 02:46 GMT | 4 |
When trying to open a DB file I keep getting an error that "The SendKeys action needs the (My Database) utility be loaded." This DB worked fine on XP. I loaded Office 2000 from the Original CD and got all the updated from MS. Then I even copied the whole Office 2000 from my ...
|
| Newbie question | 19 Mar 2007 02:01 GMT | 6 |
I am creating my first Access DB - and have succeeded ti creating an update query which works - except for the part where I try to update a field :"in place" by 1 The way I have the query set up is
|
| Filter .csv on import | 19 Mar 2007 01:46 GMT | 1 |
I've created an import specification that will import a .csv file into a table. It works just fine except that the program (our print tracking software) that creates the .csv file will put the header information in the first three rows, and the last three rows are
|
| IMPORT DATA TO ACCESS FROM REMOTE SQL SERVER HELP | 19 Mar 2007 00:24 GMT | 13 |
I have a local Access DB which I need to import data from a remote SQL server once a day, is there any way of doing this automatically? regards Simon
|
| Time Date Query | 19 Mar 2007 00:21 GMT | 1 |
I have a form that records Date In, Date Out, Time In, and Time Out and I am looking to create a query to give me the differance in minutes. Each of these fields are seperate. I was able to create =[DateIn]+[TimeIN], but I cant seem to get it to due something like this
|
| Trouble with a simple formula | 18 Mar 2007 23:01 GMT | 4 |
I have been trying to get this to work in a form to add 1 3 or 5 years for the choice in the drop down [risk factor] to an entered date field [date of last FSMP] and display it automatically. =IIf([Risk Factor]="High - Annual",DateAdd("yyyy",1,[Date of Last
|
| Docmd.Transfertext 'Autocorrect' error | 18 Mar 2007 22:27 GMT | 2 |
I'm using the Docmd.TransferText method to import data from a text file into a table. It works just fine, but it creates a table every time called "Name AutoCorrect Save Failures", and that table contains four fields, essentially telling me that it could not save the object
|
| hello everyone - im dead! | 18 Mar 2007 20:50 GMT | 1 |
I have Windows Vista Business. Does anyone else because I have Sonic Solutions DLA and everytime I boot up my PC, it just keeps popping up saying 'Program Compatibility Problem' and it is really annoying because I have to work
|
| Tables | 18 Mar 2007 20:47 GMT | 1 |
I need to add a column and create an IIF statement Can I do this in a table or do I need to do this in a query The result of the if statement will be a filed that I will need to use as a replationship
|
| change format language | 18 Mar 2007 20:45 GMT | 1 |
how do i change language in programme from german to english. down loaded "lexmark quick books plus 2007" in german. can you change to english when you open programme.
|
| include null count in total query | 18 Mar 2007 20:32 GMT | 3 |
Is there a way to include null values in a totals query. tblCharity charityID = eg. a b c d tblEvent
|
| Sort a Concatenated Field | 18 Mar 2007 20:26 GMT | 3 |
I don't know what I am doing wronge, I have this in the RECORD SOURCE area for a form: Subjects: Concatenate2("SELECT Format(Last,'>')&', '& [first]&' '&[middle]&' [DOB/'&format([dob],'mm-dd-yyyy')&']' FROM tblPerson INNER JOIN (tblOperation
|
| Spell check - Access vs Word | 18 Mar 2007 20:08 GMT | 4 |
Does the spell check in Access 2003 use the same spell checker as Word? I have a memo field that users can right mouse spell check but they say that Word provides a better spell check. TFH
|