Search results

This may be a silly question, but does anyone know the keyboard shortcut to Run a query when it is in Design view?

Null thanks for that, I will make sure i use it in the future! I've used the above, but if you enter an e-mail address, and then remove it, it returns the invalid email msg box.

i have just got into vb so i really should learn things like that, thanks! So I should use str for strings, txt for text boxes etc, yes? Thanks for the help.

I'm probably missing something really obvious, but I can't see it!!! I have an email address field in a form. When the user exits the text box, I need an emailaddresscheck function to be run. Here is the function: Public Function EmailAddCheck() Dim blnValid As Boolean blnValid = True If...

i thought that it would of been because the table is open, but it is not. i'm really baffled why the export does not work! Thanks for the file exists check, it looks excellent.

there is no checks as the export will only be run once a day. besides, i'm too much of a beginner to know how to do that! when you type transfertext, it shows that there are the HasFieldName and HTMLTableName options, but also a codepage option. Hence the " 1, , 1" after the filename. jempie

I have the following code in a module: Private Sub Exprt_Click() Dim strFileName As String Dim tOutputPath As String strFileName = Format(Date, "ddmmyyyy") & ".xls" tOutputPath = "E:\Jemmo\BMK Classified\SamplesForBMK\" DoCmd.TransferText acExportDelim, , "This Week-Deduped", tOutputPath &...

I need to bring up the import/export wizard on the click of a button, or upon startup. I have looked in the help and on the net, but couldn't find anything. Can anyone help?! Jempie

that's exactly what I'm after. Thanks! :)

Apologies, but I am an Access beginner and not sure what you mean below. I used macros, rather than a module for the Maximise and Restore functions.

it might be better to explain my situation. I have a main menu, which I want to always stay open, and always stay maximised. When I use the restore function, it turns all the forms back. Is there anyway to set the main menu's size to default to maximised?

I've used the above macro, and it works a treat, thanks. But what if I only want the form that I set the maximise macro to run upon load to appear maximised. When I open other forms they are opening maximised, how can I stop this? Thanks.

the table is imported into access. whenever it imports the table, although i can set the field to text, i cannot set the field length if the file is comma seperated. I guess i will just have to stop trying to create shortcuts, and make sure that I do it manually! Thanks for your help anyway...

I have a table named (say Table1), with two fields (say Field1 and Field2). I am trying to create a macro that will set both Field1 and Field2 to Text with Field Size of 10. Is this possible? Regards, Jempie