Search results

Hi, It has been a while since I used Access and I've come to a point where I'm struggling. I am trying to create a report from a query that I have created which looks at the total hours individuals have done on a month by month basis, the hours have also been split into the different project...

I am trying to stop access displaying the "You are about Update 1 Record" etc message when i run an update query. I know i can do this in Tools/Options screen but the problem is that the database is going to be used by multiple users, and rather than changing each persons Action query option I...

I am trying to create a form that is based around a league table. When it opens i would like access to extract specific information from one of my tables and then display the records in a specific order. This order will depend on how many check boxes have been ticked. The form will be used to...

Right my problem is this. I have set up a form where the user inputs a information regarding a train journey. At a certain point they need to enter a start mileage for the journey. Once they have updated the field a macro is run which queries another table identifying what journey they are...

Geogis Id ELR TRACKID1 START MILES FINISH MILES 1 AAV 1100 29.0110 29.0154 2 AAV 1100 29.0154 29.0215 3 AAV 1100 29.0215 29.0550 4 AAV 1100 29.0550 29.0638 5 AAV 1100 29.0638 30.0000 6 AAV 1100 30.0000 30.0001 7 AAV 1100 30.0001 31.0000 8 AAV 1100 31.0000 31.1694 9 AAV...

Can someone help?? I am trying to allow a user to input a zero into a field as the first character. At present i have changed the fields property to text which will allow the user to achieve this. However, i am also using the entry to make another field visible/invisible. I had originally set up...

I am currently trying to create a query where I can search a string of numbers and indentify all records contain a specific number. I can do this using the Like "*2" but rather than having to change the number i am searching for everytime, i want to enable the user to input there desired search...

Really easy one this but how can i set the height and width of my form through vb. I have a form with two buttons and some text, and a whole page looks daft. I just want a small window to open. Not really with it today.

I have created an append query to transfer some data from one table to another. This works fine but For some unknown reason it is not picking up all of the data. It is leaving out one row of data. The query picks up data that has been ticked off as complete but when i go to move them across, by...

I am producing a database to allow a comparison of two of our products. THe database is fairly straight forward with the user typing in certain fields such as TrackID, ELR Number etc. As well as this information They are embedding pictures of the differences between the tso bits of software. All...

I am producing a database to allow a comparison of two of our products. THe database is fairly straight forward with the user typing in certain fields such as TrackID, ELR Number etc. As well as this information They are embedding pictures of the differences between the tso bits of software. All...