Search results

not sarcasm, i was just agreeing with you, always been the same but they wont change. Thats life!!

oh yes, the business have no clue, it is all output, output. thanks anyway

i agree its a bad idea, but that is not the point, it still needs to be done as its what the 'Business' wants. Seperate tables, that can then be exported. So is there a quick way of doing this, as i have over 100 tables to create?

because its what the 'Business' wants, believe me, i have asked the same question time and time again. so is there a quick way, as i have over 100 tables to create.

Hi Is there a quick way to split up a table into many other tables? I want to split the table by Client Number, so all the Clients with 1234, for example, are in a table called Client1234 I know the very long winded way, creating a ‘Create New Table’ query, inputting the Client Code criteria...

Hi Is there a quick way to split up a table into many other tables? I want to split the table by Client Number, so all the Clients with 1234, for example, are in a table called Client1234 I know the very long winded way, creating a ‘Create New Table’ query, inputting the Client Code criteria...

Thanks for this Was still having problems but not to worry as I have now changed the way my database works so this function is not needed. Thank you for your help anyway. Keith ;)

This is my code, what i am doing wrong? Public Sub Add_new_request_Click() DoCmd.OpenForm ("Project Log Sheet") DoCmd.Maximize DoCmd.Close acForm, ("Main Page") If MsgBox("Do you want to add a New Project?", vbQuestion + vbYesNo, "Add a new Project?") = vbYes Then Call AddNewProject_Click...

Modest, something like this? Public Sub Add_new_request_Click() DoCmd.OpenForm ("Project Log Sheet") DoCmd.Maximize DoCmd.Close acForm, ("Main Page") If MsgBox("Do you want to add a New Project?", vbQuestion + vbYesNo, "Add a new Project?") = vbYes Then DoCmd.OpenForm ("Project Log...

ok i see, I do have code in my database but no modules, so they are linked to the forms. I dont have a clue regarding Modules, but is it possible to put all my code into one module so they are all in the one place, will this help? cheers

does not work i get this error Compile error: Sub or Function not defined I have no code in any modules, on the Project Explorer all my Forms are listed with codes asscoited to them. Is it best to use modules then?

Please Help Hi This is my code: Private Sub Add_new_request_Click() If MsgBox("Do you want to add a New Project?", vbQuestion + vbYesNo, "Add a new Project?") = vbYes Then DoCmd.OpenForm ("Project Log Sheet") DoCmd.Maximize DoCmd.Close acForm, ("Main Page") Here I need code to run another...

Fair point, sorry to you all, i will try and explain more carefully in future coley

thanks to all the people who answered this, apart from Ken because 'Do Stuff' isnt really that helpful, is it? cheers!!!

great!! any normal answers from any normal people

Hi I have this code Dim UserResponse As Integer UserResponse = MsgBox("Do you want to add a New Project?", vbYesNo, "Add a new Project") If UserResponse = vbYes Then What I want is when Yes is clicked is to run another bit of code I have typed for another procedure. Thanks Keith

Hi When I start my database I have set it up so a certain form opens as the Main Page, how do I get this to open and then Maximise automatically straight from start up? Cheers Keith

sorted!! the problem was in the query, and the join properties not the code thanks to all that helped Keith

dont think this is what i am looking for, but thanks anyway, I enter new records in another form, when i open the table the new records are there but they do not show on the report.

I have found the cause, but not the soloution It is not showing any new records I entered, on the report i run using this code: Private Sub Command7_Click() If Not IsNull(Me.txtFromDate) And IsNull(Me.txtToDate) Then MsgBox "You must enter a To Date, please try again.", vbCritical...