Search results for query: *

Importing Text files into Microsoft Access using the included ISAM driver requires that lines not exceed a certain length and that lines are terminated by both Carriage Return and LineFeed characters. I don't remember the maximum line length, possibly 255, or maybe 1024. I have had this...

Unfortunately, there is no easy, built-in way to do this. I too have wanted this feature at various times in the past, but Microsoft Access doesn't natively support it. The new record for Datasheets and Continuous forms will always be located at the bottom. Although I haven't tried this...

The sendobject command doesn't support any criteria or options for the report. What you have to do is write code that opens the report in Preview Mode, using DoCmd.OpenReport and providing the whereclause that you desire. Then, call the DoCmd.SendObject with the objecttype of acSendReport and...

Ok, The reason that it is only working for the first record is that you have to realize that the "TransferDates" function doesn't know *anything* about the rst you have declared in "MoveDates". Looping through each record of the recordset in "MoveDates" does...

Queries and Tables have a maximum of 255 fields, so that isn't your problem. How are you editing this query? Is it a saved query? Are you opening it from the Queries tab of the database window? Or are you clicking on the elipses (...) next to the recordsource property in form design view...

Ok, Well, the solution I posted is still basically correct. List boxes are not searchable by themselves. You have to search through them in the way that I have shown. The difference could be that instead of just selecting the item that matches, you go ahead and run the code that adds that...

Vic, Ok, I think I understand your problem and I might be able to help. First of all, are you very good with VBA coding? This report is going to require some serious code to get the results you desire. I will outline my suggested solution and then we can discuss actual code later after you...

How are you executing the append query? From code or from a macro? The best way would be to execute it from code, and use a querydef object. This method doesn't present any error messages to the user unless the query itself has a syntax error. You would do something like this: Dim db as...

Do I understand your question correctly, you want a user to be able to type in the name of an item in your list box (or partial item name) into a text box, then have the list box automatically select every item in the list that matches? For example, items in list box: Fox Hound Fox & Hound...

Hello, What version of Access are you using? Also, please describe the layout of images on your report. Are there multiple images being displayed/printed on a single report page? I had some problems with images in Access 97 a couple of years ago. I ended up contacting MS Support with...

The filename is returned as a null terminated string that is 256 characters long. In order for you to use it, you need to remove the trailing null characters (appearing as "|") Public Function TrimNulls(strInput as String) as String Dim x As Integer x = InStr(strInput...

I am afraid that I don't quite understand your question. "How would you return a value of the current record." Return the value of the current record from what? Your form that launches the report? Or the report itself? If you are talking about the form that launches the report...

You are so very close. Basically, you need to add only 1 (one) line of code! You can tell the .sendobject method which report to send in two different ways. The first way is to do like you have done. By explicitly naming the report that you wish to send. The second is to leave the...

Are you trying to create a comma delimited or fixed width text file? If so, look at the online help for DoCmd.TransferText You can create a query that has the fields and records that you want to export. Then using DoCmd.TransferText you can export that query to a text file. This is the...

Lisa, Please explain what it is you are trying to do with form 2 after it pops up. You previously said: "I need form #2 to open with a new record and the matching field from form #1" The example that I provided opens the popup to a new record and populates a field in that new...

SubControl is the name of the Sub Form Control on your main form. Replace subControl with whatever you named your subform control.

The error message means exactly what it says. A record in a table cannot have Null as the value in the Primary key field for that table. What is happening is that the events occur in a specific sequence that is making your "OnClose" code too late. I am guessing that your user is in...

Most windows applications, including Microsoft Access only respond to Alt+ combinations that are on the form that is currently active. So, the method that you are attempting to use would only work if you define Alt+C on all of your forms to do the same thing. This would be a mistake and quite...

Your approach is close, however, you are telling access to basically find the LAST match since you never let the user see any of the intermediate matches before moving to the next one. Your .findnext should not be in a loop. What I have done in the past is provided a text box on the form where...

Andrea001, Ok, I think this is what you are looking for. For our example, the name of the ID field in the table will be "FieldID" and the name of the text box control on the form that is bound to this field will be txtFieldID. Of course, you will substitute your actual field and...