Search results

I keep getting the above error in my code and don't understand why as it has been working for weeks!!! I have a form with 3 combo boxes that I have been using as a filter for another form. This has been working fine and I don't recall changing anything within the 2 forms recently. Some advice...

I have taken yours and others advice and research and normalised my database. Its much easier to work with now Thanks for the advice

I have done some research on normalization and have changed my database accordingly. It is now far easier to work with, thanks for the advice

Hi again, sorry for all the post asking question rather than answering them im still a little green! I have the following code setup to alter a query before opening a form within VBA, I have the code place in a buttons OnClick Event and the code is referenced via a separate module The code...

Thanks This is only my second project and I am self taugh so all help is greatly received

The database in question is for recording staff training There are 10 departments for staff to work in There are up to 28 individual tasks for each person to train in and a date that the person has been trained stored within the tables for each and every employee. Therefore I have 10 tables...

Can you not limit your user data input via combo or list boxes rather than text boxes? This would negate the need to flag up there errors

I have a form in my current project that I need to copy and use to control data input into 10 different tables, i.e 1 form for each table. Each form has 168 text boxes which I need to change the Control Source and name of. I know how to change a forms control source and an individual controls...

I have written some code to alter the format of a text box when a specific date range is found in the Dlookup. Please bear with me I am relatively inexperienced in VBA! Private Sub Command590_Click() W = Now() Dim X As Date Dim Y As Integer X = DLookup("[ISSUE DATE] ", "[MasterWiList_Qry]"...

Thanks for the responses. Shortly after posting this I realised that I could achieve what I wanted by using the tab function. I have approx 150 text boxes to put on a form but wanted the whole form to be visible within a single screen!!!! Thanks again

Has anyone tried to do this before:confused: I need to split the form into 4 section, 3 of which I need the function to collapse or expand If this is possible could someone point me in the right direction please Thanks

Hi This may sound basic but I am completely stumped. Funny how the simplest of problems can become the most difficult to solve! I have an issue with a field within my pivot table basically the pivot table will only return a value of 0 when the query returns a calculated value and the pivot...

Thanks for the heads up, the macro issue might be a problem as my current DB has quite a few! I suppose im going to have to push ahead and deal with the issues as they arise Cheers

I have an access 2003 DB that is deployed across a medium sized business, unfortunately we need to purchase new computers and they will come with vista and office 2007 Has anyone had any issues with running access 2003 databases with access 2007? Any info would be greatly appreciated as I...

that works great, thanks a lot for your help and patience!!!

Easy when you know how; works a charm like that just get my blank query pop up if there is no matching record. I still cant get my message box to only display when there is no result in the query would you be able to point me in the right direction on this also? Again thanks for the help

That sounds more logical to do it that way! I am fairly new to VBA Access and teaching myself as I go, therefore the code I have used is just the way in which I have managed to achieve what I wanted. Please could you post the appropriate commands so I can try the way in which you have...

Hi I have coded one of my forms in a database to search a query via a unique process number entered into a box within the form. If the process number in the form matches one in the query,the relevant query record is displayed. If no match is found a message box telling the user that no match...

No the query is updatable. I have fixed the problem now though, I had to remove the extra column and link that I had added to the query. This then gave me the ability to delete records without them reappearing on reopening. I then rebuilt the extra column, references and links and all is fine...

Sorry should have been more specific, please bear with me as this is the first access database I have put together. The records are deleted by an admin user via a password protected front end, they select the appropriate record in the results query and hitting the delete key, access flashes the...