Search results

Hello, I am looking for a little more help with a database I am currently creating. I have a main form which contains a subform, both of these forms are controlled by a combo box which allows me to select records on the main form and displays the matching information in the subform. I would...

Hello, I am looking for some help with a Yes/No tick box on a subform. I have a combo box (combo20) on my main form which finds records on my main form and the relevant matching details on my subform. What I would like to do is -------------When the Vehicle number is selected from the combo...

Hello, I'm hoping someone can help me (Im not the best with MS access so please bear with me. I have not yet started this database yet but what I need to do is have 2 tables, 1 which records 'live' data about our fleet of vehicles and 1 which contains the historical data, both tables will have...

Hello, I am looking for a little help. I have a report which works fine but I want to pull in data from a different table that the report is not based on. The report is based on a query named MaintenanceQRY and it has a field in there named 'ItemUsed'. Like I say the report works fine...

Hello, I have a main form which in turn has a subform showing the brief details of vehicle checks that we carry out. The subform has a field next to each check 'Date checked' and also a command button which when clicked opens up a another form which shows all of the checks carried out on a...

Hi, I have a search query on my access database which uses a form to set it's search criteria. The form asks for Start Date, Start time, End date, End time. If the user specifies 1 day and a set time criteria the search works fine. If the user specifies a date range we then have problems...

Hi, I am looking to create a simple database which has a list of parts and their stock levels and when I raise an order it takes the quantity ordered from the current stock level. I have looked at lots of templates but they're far too advanced for what I need. I simply want to be able to...

Hi, I have a query in my Access database which works out the duration of a job. The Query has 2 columns 'TIME IN' and 'TIME OUT' then there is a calculated column which calculates the duration of each job. The problem I have is that when there is no times entered into TIME IN or TIME OUT...

Good morning, I received some help on here yesterday which enabled me to find out the total hours worked by one of our employees for a day. I am now looking to see if there is any way I can add these daily total hours together to find out the weekly total? I have a query which has MON...

Good Afternoon, I'm looking for some help with an Access Query. I am creating a time sheet / pay roll database and I want to be able to get a total of the daily hours in a query. For example I have 'Mon Start' and 'Mon Finish' for Mondays in/out times and I have a 'Mon Total' which...

Hi, I am looking for some help with displaying the totals from a query onto a form. I have a query which has a total line showing a count of the number of entry's in each column. I would like to be able to display these totals on one of my forms in text boxes (or any other way). Is...

Hi, I have an Access query which has 2 fields 'Sent Date' and 'Return Date'. Sent date is input by the user when they return an item for repair, return date is input by the user when the item is sent back to us from repair. What I need is a 3rd calculated field which will work out the number...

Hi, I have an access form which has a combo box on it which allows a user to select YES or NO. I also have a command button on the form which when pressed sends a report to the intended recipient. What I want to know....is there any way that when the command button is pressed the combo box on...

Hi, I am new to access and I'm having a little trouble using IIF statements. I have a field in my Access table named 'Date Checked' a one named 'VIP Pass' and a one named 'VIP Fail date'. What I am trying to do . . . If the answer in the 'VIP Pass' field is NO I need the 'VIP Fail Date'...

Hello, just joined today hope I can get some much needed help !!!