Search results for query: *

To Gripe #1 - When saving in Illustrator 9/10, it will prompt for a "pdf compatible". If this is checked, you shouldn't have those kind of problems.

1) Reboot (Your)System 2) UnInstall Office 3) UnInstall Printers 4) Re-Install Office 5) Re-Install Printers

Perhaps you could create a shortcut with an indication to run that macro when opened from the shortcut link. This way, you could open it both ways...

...bytChoice = vbCancel Then LastName.SetFocus Cancel = True Else CurrentDb.Execute "Delete * from EmpAudit where EmpID = " & Me.EmpID strSQL = "Select * from Emp where EmpID = " & Me.EmpID Set rs =...

Yep! That worked! Thanks...I have some other problem in my code where if I chose to delete the information, it cancels my action. I know it has to be in the if statement somewhere.... Anyways, thanks for your generous help!

Yes, I am...

...bytChoice = vbCancel Then LastName.SetFocus Cancel = True Else CurrentDb.Execute "Delete * from EmpAudit where EmpID = " & Me.EmpID strSQL = "Select * from Emp where EmpID = " & Me.EmpID Set rs =...

Thank you for your response. I haven't tried it yet (I only work half days). I will definitely let you know if it works. I thought you could do it programmatically! Thanks so much!

Hello! I have two tables, one is Emp (basic employee information) and the other is EmpAudit (results from auditing file). They are linked using the EmpID, and EmpId is the primary key in both tables. I've been trying to create a re-hire button that eliminates the record in the EmpAudit table...

I am working on a computer inventory database. We want to record some of the individual components in the various machines (as we build all our computers in-house). I have made a table for components, a table for configurations, and a table for software. I would like to be able to use a form...

You can put a page break by grouping and sorting your subreports together, than you can specify which groups to put on a page. Go to properties and under format there should be a "Force new page" option with non/before section/after section/before and after options. Good luck!

Omega36: Thank you for sending us the database...and for posting it for all the others! I really appreciate all the knowledge-sharing that goes on here! Thanks again!

Yes, it is possible. Are the fields in the subform in the same table as the fields on the main form? Or are the fields on the subform in a different table?

Use the drop down list wizard to create a drop down list (combo box) to select data. One of the options in the wizard allows you to have it automatically find that record based on what was chosen in the drop down list. This is the easiest way to do it for a simple db.

YOU ARE SO VERY AWESOME! That worked. Just for future knowledge...why does that happen? I am a beginning programmer working as a MIS intern, and I am not too familiar with Visual Basic, and I am teaching myself.... Thanks again for your help...

Hello. I am working on a workorder form that, after an update, opens and finds the inventory record in another form. I keep getting "Run-time error '2501': The OpenForm action was canceled. This is what my code looks like. If Me.Dirty Then ConfirmChg DoCmd.OpenForm...

Thanks! I could not figure out where to begin!

I would like to force one field in a form to store only capital letters, while the rest of the form is in the first letter capitalized form. Anybody know how to do this via code? I think you would use the Key Press, but I have NO sample code...and I am lost.... Thanks!

What I ended up doing was designing a make table query, pulling out all of the hire dates from my employee table, and using expressions to calculate the 90 day and 1 year eval dates. I then created a different query to pull that new table's information to a report. Thanks for your help, though!

Darrylle/Shannonp1: On my form, I have an actual field for the hire date. On the same form I have done exactly what shannonp1 has suggested. Now, on the report I am trying to create, I need to set parameters so that the user can enter say, all the people that are up for a 90 day eval for...