Recent content by jjarman

It might work... but I believe it would still need to run a query, comparing the title and revision of the document, to a record in the database so that it only returned 1 record to merge.

Is it possible to link a field in Access to a footer in Word? I have a field in Access that would look like the following; G10E-PRO-001RevA Additional data in access would have the document name, and revision, matching 2 lines of text in Word. I would like the footer in the document to be...

I have 10 fields in a report, all with thin solid lines around each field to form a grid (similar to an Excel spreadsheet). Most of the fields will never grow as the data is something simple (date, yes/no etc), however a couple fields are allowed to grow depending on how much text is in them...

Got it working, thanks!! The only benefit to doing it in Excel was the fact that I could see all the relevant information in the table (overdue items) as it would update automatically when the file was opened... in Access I have an extra step of generating a report. Regardless, I think Access is...

OK, if I can get my head wrapped around this... what you're saying is I should maybe have a field in a report that does the calculation? As long as the value is not stored anywhere, and calculated on the fly it should work. The IIF statement makes sense... I'm assuming I can use a text box for...

Hoping someone can help, again! The project I'm working on is an action list with the following tables; itemnumber - autonumber PK originator - text dateentered - date/time actiondescription - text assignedto - text targetdate - date/time forecastdate - date/time actual date - date/time...

Is it possible to follow a hyperlink to a file without using a file extension? I have links being created based on the name of a file, but because I haven't used a file extension it crashes. I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's...

Thanks for the help. Managed to get this working... once I broke it down and started to understand what it was doing! But I could use some advice on setting up a report to show the info the same way I see it on the form. For some reason I'm only seeing the first record from the subform in the...

Is there a way to open a form from a form in a different database? I'm pretty sure it needs to be done in VBA and have seen some code floating around that suggests it can be done, but I'm thinking there's more to it, like maybe one or both of the DB's need to be in a different format? Thanks

I guess the other question I had, do I need to have another table or form to record services associated with a record in the assign table?

Not sure what a Foreign Key is. In the assign table; - PK is an autonumber field. -projectcode, customer, projectdescription and manager will all be looked up in the linked table called ITEM CODE in which the field itemcode is the PK. - employee comes from a linked table, only one field...

Yes the linked table "services" is a predefined table that has the service and rate associated with it. There are 2 other linked tables, also with predefined information; employee, which has employee names AND ITEM CODE - which has the details about the project itself. Essentially what I want...

There is a linked table called services which has service and rate in it, service being the PK. The table called assign has the following in it; autonumber - PK project code, customer, project description, manager, createdate AND service and rate, which I assumed I needed to have in it. I...

I think I'm on the right track with using a subform, but could use some guidance. I have a form that tracks job assignments, and I need to have the ability to have multiple services assigned to each job. I'm assuming that a subform is the way to go as some jobs may only have one service on them...

The column count is set to 2, the widths were 0",1". I have now changed the column count to 3, and the width's to 1,0,0 Bound to Column 1. There are a lot of smart people in the world, Thanks for the help!! :)