Search results

All fixed now. Created a query based on fields from all of the tables that could be pre poulated, hid them in a new record form and then when hitting the close button, opens the customer record with the tabs all working. Thanks both!

VBA, yes I do. Galaxiom, I know the subforms would only create a record in the table if there is information added. What I want to do is create the ID number in the table as soon as the General table is created. So I guess my real problem is can I somehow make it so that when the information...

Existing records all show correctly, they are all linked Master/Child etc. I have just created a new record and it does put the information in to the General table correctly however if I have a form that searches for the last record, it does not come up with that customer it comes up with the...

Hi, I got a problem. I have a form that has multiple tabs (pages) and I need to use this form to create a new record. The only problem is that when you put in the initial information in the first page, as soon as you go to the second page it does not create the ID number (created from page 1)...

Hi Bob, Main problems I have with normalisation with the Industry we are in is that every year, the same field used on a piece of paperwork may have its criteria changed. This would then be a nightmare as when one code would have worked in a previous year, it may not this year. I have thought...

Never mind, all fixed. All I did was put a condition in that was ([TempVarName]="AcademicYear") then used an OpenForm command to open the correct form. Maybe this can help someone else who are a little simple like me :) Ineedcoffee

Hi All, I have been trying to create a Listbox that has names of forms in it. I then want to be able to open the form that coresponds to the users selection. It is based on Academic Years, so 07/08, 08/09, 09/10 and so on. When the user selects a Year I want it to (in the After Update) open...

pbaldy, Thank you so much. All sorted. Cheers, Ineedcoffee

Hey, Been trawling through the forums for the last 2 hours and I am now officially sick. I have some code when a user first logs on, it brings up a login form, when they put in their user name and password, they then have to click on the login button for it to close the login form and open a...

Was just what I was thinking. Was trying to find a way of making the built in database query's differ from those user created. Another thing is that every new update I do with the front end will wipe out users query's. I was thinking that I could have the users create the query on the back...

Hi vbaInet, Thats great, I will have a look at doing this later this afternoon. The only thing I can see wrong with what you have said is that the code used will list all query's on the database not just the user created ones. I will have a look at seeing if I can only call those that are in...

Hi, Ok, long story short. I need to be able to disable the Navigation Bar (so users can not mess about) however still allow users to create and run query's. I thought of a way of creating a query button that would open a form that would list all of the available user created query's. However I...

Hi, Its the 32 bit version.

Just a quickie. I have just set up a Windows 7 machine in the office and for some reason the links to documents in my Access 2007 database dont seem to work. Is this a problem with the shellexecute command? Does Windows 7 work this differently than Windows XP? Any help is greatly appreciated...

Thanks again, I have managed to get it to work. What I was doing is using a field and dividing that by the text box name. I now have it so that it is showing loads of numbers after the decimal point and I have set the number of decimal points to 1 however this is also not working. Probably...

I have managed to get a count for the records working along with the sum of the fields however for some strange reason I can't divide the two numbers. It comes up with a message box asking me to input a value for IDTotals (this is the name of the text box that I have that counts the number of...

Hey Dave, Can't believe I missed that, knew it would be something simple. Yes it does work in the header without code, no idea why but it seems to be doing it. I do now have 2 problems. I am trying to create a graph based on the 'summed' results and I can't see how to do this. Also the chart...

Hi, This might be really easy but can't seem to find anything on forums about it. I have a table of survey results in. The surveys have approx 10 questions and there are 2 of them. My grouping is by geographical area's. All I want to be able to do is not show each individual record, but only...

Ok, I don't have a field that stores the path to the file, at the moment I just use the built in Access attachment field. I did not think that this was the field that stores the file path or does it?

I have tried the code and I'm coming up with an error when compiling, error is to do with intSplit = InStrRev(Me.DocMgrPath, "\") the error is Method or Data member not found. Not sure what I have done wrong, any advice? Thanks.