Search results

There may be other ways but: Change your control source to ="'" & [YourField] This will export it as you want. Can you export the query instead of the report?

Are Form1s Modal & PopUp properties set to true? Is Form2s PopUp property set to true? Try setting them all to false.

1: You have nothing to link the two tables. Try looking up relationships in Access Help. 2: You're having 4 lines on the second form, because the admin user may have 4 entries to do and this will enable them to do them all at the same time. What if they have 5 ro 6 or 9? Will there never be...

Sorry just re-reading your original post. You are trying to get data from one database to your database. You are exporting this data as an Excel spreadhsset then importing it in to yours, correct? From a personal point of view I don't think Excel and Access 'get on' when it comes to importing...

Do you know why these memo fields are being truncated? How many characters are in these fields, thousands?

Try changing you import file to just have the first line in it. IE a one line file and see if it imports it with your import spec etc. If it doesn't import it, which it sounds like it won't, then I'd recommend taking another look at your spec or creating a new spec and seeing if that works....

Change the KeyPreview property of your form to Yes. Then put the following code in the forms KeyDown event: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyF3 Then MsgBox "F3 Pressed" End If End Sub Hope this helps....

This post is old so you may have found an answer. You can do it easily in code using a loop. myfile = dir("c:\The folder containing your files") do while len(myfile) <>0 Import your file here myfile = dir() loop

Call the macro AutoExec and it will start as soon as the database is opened.

Not sure exactly what you're trying to axchieve here. Are you just trying to import a file? If so rather than using sendkeys you could use a macro using TransferText or write 1 or 2 lines of code to import the file, giving you far more options.

Hello. You're going to have to code this rather than do it in a macro. Basically, I understand what you need, you want to design a form. With a button on it. On the click event of this button add your 1 new fixed record to the table/s. Then perhaps ask how many other records are to be...

Have you tried compacting each of the backend databases?

I'm presuming you have 2 or more tables. One with the emloyee names and one with the pay rates. What is the link between the tables? Sounds like this is where you problem lies...

The intCurrentRow is supposed to be an Integer. But for some stupid reason I didn't type that. Apologies for not being perfect. I don't claim to be any sort of Access genius, I was just trying to help someone out. So I have learnt something new from this post as well. But there's no need to...

Try this: Private Sub Command1_Click() Dim intCurrentRow For intCurrentRow = 0 To List1.ListCount - 1 If List.Selected(intCurrentRow) Then Text1 = Text1 & List1.Column(0, intCurrentRow) Text2 = Text2 & List1.Column(1, intCurrentRow) End If...

Sorry, not sure what you mean. If you mean how do you make the tab visible use: TabCtl0.Pages.Item(1).Visible = True

Depends where you want to display it but: Msgbox Now() On the click event of the button will do it.

When the user selects Metric or Imperial you could make the relevant tab invisible: TabCtl0.Pages.Item(1).Visible = False

On the list box properties change the 'Multi Select' property to simple or extended. The following should give you a general idea of how to achieve what you want. Private Sub Command4_Click() Dim intCurrentRow as Integer For intCurrentRow = 0 To List2.ListCount - 1 If...

I'm thinking you mean the message from Access which says something along the lines of 'The OpenReport action was cancelled'. If so, it's because in your Button_Click event you've got an Error Handler. Either comment the MsgBox Err.Description or trap the error number of the error you're...