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...
...Integer
Dim lstCount as Integer
lstCount = Me.lstItems.ListCount
For x = 0 To lstCount - 1
If Me.lstItems.ItemData(x) Like Me.txtSearch & "*" Then
Me.lstItems.Selected(x) = True
'Call your code that moves this item
'to the adjacent text box
'Then, since items in...
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...
...= False
End If
Next x
'End of code to clear selected items in list
For x = 0 To lstCount - 1
If Me.lstItems.ItemData(x) Like "*" & Me.txtSearch & "*" Then
Me.lstItems.Selected(x) = True
End If
Next x
Note that if your list box has multiple columns and you need...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.