Search results

I hope someone out there has seen this and knows how to deal with it. I have a split database built in Access XP, where the front end has a reference to a code library file (.mde). I have two users one of them is on Windows 2000 - this user can log in a use the databases with no problem. The...

Sorry - I have one more thought. Why not have both the table database and the other database on the server and let everyone access that through one Icon on the client machine. In additon to the "production" version of the database put a copy on the users desktop called the "design" or "test"...

Brian - What happens if a user makes changes to their front-end database but does not give them to you to update the template and then you synconize to the master copy? Do they lose all of their individual changes? Just wondering GumbyD

This will fail if there is more then one person due to passive locking. Microsoft added passive locking as a "Feature" to Access 2000. If there is more then one person in the database then you cannot make changes and save forms or reports - this includes new objects. If you are getting this...

Keith - In the help menu take a look at "Create a multiple-column report" GumbyD

In the control souce put: = Left([FamOrTreat],1) GumbyD

I think what I would do in your case is put the subform value that you need as criteria on the invoice report query. So you need to figure out what values on the form as criteria give you the unique invoice that you want and then do form calls in the query criteria for those fields on the form...

You need to use an outer join from the larger table to the smaller and then use is null criteria on the key field in the smaller table. So for example in table 1 you have 10 employees and in table 2 you have 5 employees to get the 5 employees in table 1 that are not in table two you would...

If you only want to update the tables in a specific table/query than only put the fields from that table/query into the grid of the query. As long as the query remains in an updatable state then it will only update the fields in that table/query. If the issue is that you want to create records...

It should look something like the following: [InvoiceNumber]=[Forms]![OrderForm]![InvoiceNumber] The syntax is: [Field Name From Form you are Opening] = [Forms]![Form Your Field value Lives On]![Field Name on Form Where Value is Coming From] I hope that makes sense! Good Luck! GumbyD

Check the Macro for criteria. On the bottom of the screen in the Action Arguments there is a Where Condition argument. You might not have it set correctly to pull the data from the form. GumbyD

A couple of things that I notice. If this is in the control source propetry of the form than it needs an equal sign in front of it. The other thing that might be causing you a problem is the field name with the "/" character in it. That is a really bad idea. I would change the name of that...

One thing to look at - in your code you Dim pcnt As Integer This should be Dim pcnt As Double GumbyD

Since you are working with currency values in the table set the data type to currency for the currency field and set the discount field to a doucle. Then on the form use the properties to set the display the way you would like. GumbyD

It looks to me like you need to divide the discount value by 100: pcnt = (.ServicePrice * .Quantity) * (.Discount/100) GumbyD

Gary - From my last post you must think I am nuts! I got this thread mixed up with another one that I have been looking at. Sorry about that. How do you distingush '921 Planned PTO' from '921 Planned PTO Sick'? Same question with the unplanned paid time off? Is there a code for 921 that...

Sorry - I posted this to the wrong thread! After looking at and working with your issue some more - there is one method I think would work, but it will be slow and ugly. Since you know it will always be 1 month of information and you have a start date. You could build subreports pulling data...

Glad you are working now. Just because I am interested- what is the KVA field in the query that is used if the form field is an empty string? GumbyD

Gary - After looking at and working with your issue some more - there is one method I think would work, but it will be slow and ugly. Since you know it will always be 1 month of information and you have a start date. You could build subreports pulling data with criteria for each week - the...

OK that was a lot harder than I wanted it to be. I ended up having to build the query in code and then delete the existing query and build a new query def for with the criteria from the from in place. You will need to modify this with your information. Private Sub Command2_Click() Dim SQL As...