Search results

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 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...

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...

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...

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...

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...

Hi, I have attachments for customers and I want to make a text box that displays the names of all attachments the customer has. Any idea how this would work? Thanks.

Hi, Just a quick one, can you make a preview pane in Access to show a document? They are all primarily pdf's as these are scanned in and we would need to view them on a regular basis. Thanks.

Hi, I am wanting to log the changes made to a customer record against a username. I have created a login form so the database stores the employee's name as a tempvar. I believe I would have to create a tempvar for every field in the forms I have (this would be approx 80 fields) and then when a...

Hi, I have a bit of a strange question. I have a split form/datasheet that shows details of our customers with certain fields on (such as First/Surname, Status of order, Area of Order, Sales Person etc) and I want to be able to make it easier to filter the data. As it stands, you can filter by...