Search results

I am comfortable with VBA and/or creating macros. I have an Access front end that users interact with. I have stripped away the database window so the only visual thing is the switchboard from which users access menu items. Problem is this. For some reason when we upgraded to Access 2007, we...

Cool. Thanks all. I actually just put a "0 +" at the beginning of my formula and it all worked out. Go figure....

I have a form where I am entering values into several fields. These fields will contain numbers that will need to be inserted into various inventory account tables to show inventory transfers from one allocated location to another. For example, I have 10 pcs allocated to 4 different channels...

Got it. Somehow the captions all went away. Putting the captions back in worked it out. Thanks pbaldy. You are always so wise and informed.

I looked into this. Wonder if I'm not using it correctly. It my control called "Label1" I put the text "Test text note" and when I put the form back to form view it then makes the control totally invisible. The control is placed within the form header and it is a Label control, not a text box...

I have created a form and the default view is Continuous Forms. I am using the Header portion of the form to put text boxes that act as column headers. Many of the column headers are abbreviated. For example, "BR" really means "Buyers Remorse", and then there are 14 more different codes. I...

Anyone out there care to take a stab at this one?

Dang it. My charts didn't post properly. THey were supposed to look like this. OrderNumber OrderExported ___________ _____________ 555666 1 666777 2 111222 3 222333 4 444222 5 111555 6 OrderNumber OrderExported...

I have a query that is used to generate some shipping labels. The order that those labels are generated matters a great deal because we use those shipping labels to go through our warehouse in an orderly fashion and pull what is on the list to be pulled. The data in the query is exported and...

I think this is what I need pbaldy. Thanks for pointing it out. So, you actually call the code from a query? I didn't know this was possible. Does the code have to be a public function, then?

I have two tables, one with header records and one with "child" records. For every Header, there is one or more Children records. The header records are orders and the child records are the items on that order. So, for example an order can have more than one item. I am essentially trying...

Thanks for the reply. I have never heard of this option. I'll take a look at it.

I have a table that I want to query (I won't put the query in here since it is so complex). This table contains items and information about items. I have another table that has orders on the items in the first table. In my query of the item table, I would like to remove any items that might...

jdraw, yes this is exactly the way to do it. I tried again and realized that I had a whole bunch of null values in my table that were causing some unwanted results. With the exact values where they need to be, it works perfectly. Then I just call the SQL statement from a form and I'm off to...

I actually created 3 tables that are each 1 column. First table is for Style, second is for Size, third is for Sizes. Then if I bring each table into an access query and define no relationship between them at all, then by nature Access runs a cartesian product result for this result and I get...

We often need to create product records in our item database and it gets very time consuming. I want to create a product matrix that will help me automatically build the product listings. I want to be able to enter this information into a 3 column table: Style ----- M1122 Colors ------...

Of course, you may run into problems if your employee happens to clock out for lunch but not in, or in but not out. Managing punches is kind of difficult. i did it though establishing some business rules and policies. We have instituted that if our employees miss a lunch clock-in or clock-out...

You've nailed it Scooterbug. Thank you. I changed the cursor type to Keyset. I obviously am out of my realm of knowledge here, so please let me know if you think I've done something that you think is NOT a good idea. To answer your question Purvis, I am ONLY using this recordset to find an...

SELECT SSN, PersonalPIN FROM Employee WHERE SSN='123456789' AND PersonalPIN='1234' Obviously just test data, but there is a user on the employee table with SSN 123456789 and PIN 1234. When I put that SQL into the SQL view of a new Query, I get 1 record, exactly as i would have expected.

Thanks for update again. I did as you mentioned and copied the SQL from the Immediate window and pasted into SQL View of a new query. The results are exactly as I expected them to be....... 1 record and 1 record only..... Yet, the recordset test logic is giving me the result as if the record...