Search results

I wondered if someone could help. I am trying to create an .mde file from my .mdb and each time an error message appears: "Microsft Access has encountered a problem and need to close. We are sorry for any inconvenienece" Then Optiosn Send Error Report Don't Send Report Thanks Paul

I have created an .mde but the Object window is still visible i.e Tables/Queries/Reports etc. How can I remove this so the user only see the Forms view? Thanks

Many thanks for your reply Yes more towards building SQL in VBA using strings. In particular I have written some VBA (shown below) within a Form: I know there is Data within my report by itself, but when I run through the Form there is no data just a blank report. I wondered if the quotes I...

I wondered if someone could explain something for me. In SQL the difference between ' Single Quotes and " Double Quotes and when and when not to use either. Thanks Paul

I have set up a command button within a form and wish to output results from a query for a specific company. The query has been set up. Can anyone help? Thanks

wondered if someone could help. I have just appended 100 or so records into a table. Once appended 2 of these records within the table have included the word "Null" into fields not occupied by any content. I have tried deleted the word null from the table and an error appears: "You tried to...

Sorry Date of Birth is a field name. format of dates in the table I am extracting from are 00000000 which I am converting to format 00/00/0000. thanks

I have written a statement within a select query that modified the format of a date value: Date of Birth: IIf([Date_Of_Birth]="00000000","",DateValue(Mid([Date_Of_Birth],7,2) & "/" & Mid([Date_Of_Birth],5,2) & "/" & Mid([Date_Of_Birth],1,4))) But receive the error: Undefined Function Mid...

I am trying to concatenate values from seperate columns. Which is fine, however if there are no values in any of these columns I wish to include a dot (.). I also need to add a dot (.) inbetween values. So for example Column1 Column 2 Column 3 B11 Europe would concatenate as: B11.Europe.

Many Thanks

Just used the code below to output to .csv. however Field Names have been omitted from the output .csv file. Can anyone help? Thanks Paul Private Sub export_Click() On Error GoTo Err_export_Click Dim AString As String AString = "Export_Occupancy_" DoCmd.TransferText acExportDelim, ""...

works fine. Thanks

Apologies just a quick question. No Field names have been printed. How can I include these within the .csv file? thanks

Thanks for your reply. I wish to add a static field called State and include with value

I wish to add a static field to a select query i.e a field that does not exist within a table. Does anyone know how I can do this? Thanks

Works now..thanks

I have run this command from the form i.e have set up a button to output to a csv file and written the code as an Event procedure. On click the code seems to work, but no output to that directory. There is data in the query. Thanks

I have created a button on a form that I hope will export the output to a csv file. The underlying VBA within the Event procedure I am using is: Private Sub Form_Click() Option Compare Database Private Sub export_Click() On Error GoTo Err_export_Click Dim AString As String AString =...

Thanks for your reply Its the data that I need. I am sure there is a macro or VBA code I can use? Can anyone help? Thanks

I have a report and wish to convert the output of this report into a .csv file. Can anyone help? Thanks Paul