Search results

Hey thanks KeithG! It works perfectly. So, in order to get rid of the warning messages when the form is opened and closed, I would just add this line at the beginning of your open code block: DoCmd.SetWarnings False Now I just have to figure out write the query needed to make my text box turn...

Yeah, it would be neat to have a record of who entered when, but I don't really think it is necessary. My company wouldn't really need to see those records on a daily basis, and they would probably start bringing up the database filesize at a higher rate than normal -- but it was a good idea...

Sorry for double posting, but I thought of another way that might work -- still based on the same principles of the Environ() function. What if the table tblUser had two columns. The first would list all the names of the users, and the second column would be a simple check box (yes/no). When...

So if I understand what you are saying, I would have a table named tblUser and it would have two columns, Date and User. The Date() in the open event would get the current date and time and store it in the Date column of tblUser, and the Environ() in the open event would retrieve the user's...

Actually, yes, there is a form that remains open. This is an invoice database where the back end is kept on our company server, and each of the 10 users has his/her own front end on their computer. When they wish to enter an invoice they open their front end and a main form comes on the screen...

Hey everyone, I have a crazy idea that I think would be very cool if I got it working, but have no idea where to start. I have a database that is broken down into a front end and a back end, and there are about 10 users who use it off and on throughout the day. This database has an entry form...

Hey thanks for trying to help guys, but I ended up manually going through and updating each record manually. It was a lot of work, but I had to get this thing done by friday. Thanks, Chris

1) I did run the query in design view only, but I checked to see if it worked by opening table A manually. 2)The column to be updated is from table A. (Currently it holds values from table B, column 2; it needs to hold values from table B, column 3) 3)No errors, only a warning message that...

Yep, that's verified; UPDATE TO does point to column 3 (the one with the desired data). -Chris

Hey KeithG, I completed the update. It doesn't make sense, it seems like it should work, but it doesn't. -Chris

Thanks for explaining it a little better FoFa. I tried what you said, and the query said it would effect XXXX records, but when I look at the records in table A, they still appear as the old values of column 2, table B. -Chris

Thank you for replying so quickly! I tried your idea, but can't seem to get it working. I am very new to the SQL language, and have mostly worked with querys in design view. To help you understand a little better what I am doing: Table A = Invoices Column 1 = Well Name and Number Table...

Hi Everyone, I have a situation, and I am wondering if there is a way to use an update query to make my life a little bit easier. I have a table with around 9,000 records, and 7 columns (for reference this will be table A). Column number 1 in table A is a lookup field that looks to table B...

Yep, that worked. Thanks, Chris

Woops, my mistake, I don't know why I was trying to do that when I really didn't need to. -Chris

Hey thanks, that did work without the parentheses. -Chris

Hey Thanks FoFa, it worked!!! I couldn't have done it without you! -Chris

Hi, I am just wondering if anyone would be able to help me write a section of VB code, since I really don't know VB very good. Here is what I am going for: If (([stock]-[stockbefore]+[sales]) == [oil]) { Print in Text box "OK" } Else { Print in Text box "Error" } These fields are on a...

OK, I have another question now, can a macro fill in the parameter of a query? -Chris

I am trying to run a query without the user seeing anything, but actually the more I think of I, you are right, I don't need a Close command - Thanks. But I did try DoCmd.OpenQuery "DateWellPrevious" and it didn't work. EDIT: I did get it, I ended up using this DoCmd.OpenQuery...