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...

FORGOT TO POST CODE... Private Sub Command113_Click() On Error GoTo Err_Command113_Click Dim strSQL As String Dim rs As DAO.Recordset Dim strMessage As String Dim intOptions As Integer Dim bytChoice As Byte If TeamNumber = 99 Then strMessage = "Are you sure you want to...

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...

Hello! I was working on the code, and it doesn't like the .edit. It tries to tell you to use EditMode, but that doesn't work either it says "Compile error - Invalid use of property". This is my code as it stands now. Private Sub Command113_Click() On Error GoTo Err_Command113_Click...

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...