Recent content by mbpaul

Great thank you, makes perfect sense. I figured that was probably going to be the answer, but I figured I'd ask in-case there was some nifty query and delete option I didn't know about. Like I said, nice to have but not necessary. Thanks Mike

Hi all, I have just started designing a new access database after a number of years away from it. I was far from an expert previously and now add being very rusty to that... it's been interesting. Anyway, I have what I hope to be a simple question. I currently have a continuous form (attached...

Hey I'm looking for a bit of help importing data from two excel sources to one table. I have a table with: Unit, Info1, info2, info3, info4, info5, info6, info7. I have been able to import from the first file which has all of the unit information-'info1-5'. I need to import another file to fill...

Hi, I am working on designing a database to track equipment maintenance. One of the things that I need to do is have an easy way of updating the hours from 250+ pieces on a daily basis. I have a form design (see attached photo) that is linked to the equipment list with all the information I...

Ok I may be going about this in the wrong way but I do want to store the calculated values in my tables. That is what I can't seem to do. I am trying to make it so that our mechanics can fill out the work orders with the time spent during the day then at the end of the day they can fill out a...

I tried that it still is not working. The table where the information is stored is not getting the information I think it has something to do with my control source. It seems to be, from what I can see, that I can either set up my control source for my coding or I can set it up to link it to the...

Ok so I got it to work but now I'm seeing that those calculated totals are not showing up in my data sheet so I can't generate reports based on them. Any Ideas on how to fix this. Sorry if it's a simple fix that I'm missing I very new at using access.

Thank you I got it too work. That solution was almost too simple I can't believe I didn't try that to begin with

I have a Text Box in the subform footer called 'Total Hours 2' the control source is- 'sum([Time Spent])' then in the main form the control source for the text box Work Order Total is '=[Work Orders subform2]![Total Hours 2]' then the control source for the text box 'total Hours' in the main...

Hey I am trying to create a time sheet that enables my workers to fill out separate work orders and the hours from those Work orders are auto transferred to a sub form within their daily time sheet. I have gotten all this done and I have the total hours transferring to the main form but I need...

OK thanks for the help but I'm not totally sure I understand. I tried creating a combo box but it doesn't let me. I have found the old forms they are stored in a tab at the bottom of the form page. But is there a way to link to them directly from the data table. I thought I read somewhere that...

Hi there all I am very new at using access and it is taking me a while to figure it all out. I have created a database to track our work orders. I have a form that is identical to our work order sheet to make data entry much easier. I am wondering though if there is a way to pull up old forms. I...