Search results for query: *

This was taken from me and given back, supposedly fixed and good to go, it's not. They have cut me loose and expect me to fix something that I know nothing about and is over my head. I am going to try to explain what they did. Please bear with my rambling. I guess I will start with the...

I tried the bracketing and it still wasn't working. It was not recognizing the name as that of a field name that is in the table (it was asking me to put in a value for this field). Can you refresh my memory on what an outer join is? I remember learning it somewhere and not liking it. learnasugo

My report is pulling from two tables, but the report only seems to be looking at one table. Here is how the tables look: CSR Table MMSJob - PK InDate - Date CCSR - Text CClient - Text Error Table PID - PK ErrorDate - Date Error - memo MMSJob - Number What I am trying to do is count the...

The reason that the fields are suffixed with a number is that is because sometimes we have to submit a copy of the letter that the client wants on white paper several times before it looks like the client wants. The same procedure goes for when we put it on lives (the paper that the letter will...

There are 6 tables in this db. Three of them I have no problem with, the other three will not let me create queries using these three tables. I have no idea why, they have basically the same type of relationship as the tables that work. Tables that Work Tables that don't work...

I found that problem already and fixed it. I wish it could be something that simple. Can you think of another reason why it would be in such a manner? learnasugo

I am having problems with one of my find record command buttons. It only sees the first record, if I put in another job number for it to find it says that that record cannot be found. This is the only form that I am having that problem with, this is also the only form that has all of the...

I just found out something interesting, I don't know if it is relevant, but it is interesting. The control source for the form is a query. The control source for the report is a select of the fields needed for the report from different tables. Could that have anything to do with why I don't...

Sorry, long night. Disreguard the previous thread. The text boxes in the report are bound to the text boxes in the form, and the form stays open while the report is open. Do I need to close the form? learnasugo

It is the form that I am working on and both text boxes are bound. For right now I have these to blocks of code commented out, so I can at least use the database for now. learnasugo

The front end is 5.31 MB. I zipped up the front end and the back end and will e-mail to you. Thank you learnasugo

Your suggestion did work, but my boss would have a fit if he lost the data that he has in the query (I tested it on a copy of the file). When I tried it I tried to copy the data and then paste it back in but that didn't work. Is there a way to save the data, or at least put it back in...

Here is the code for my command button. It now pulls only one button, but it no longer stores (or at least pulls) the current date and time from the database to the report, it used too but not anymore. Dim stDocName As String Dim strEmail As String Dim strMailSubject As String...

I have the record source for the form set to the query name. What I can't figure out is why those first two option (LOEmpID and LOLast) are the only two fields giving me a problem. The only thing that I can think of is because they are from a different table than the other fields. The tables...

Would I still need to set it up in SQL View if the query works? The query going into the form works. I'm going to take a stab in the dark (from what I have learned from this thread) and say that it has something to do with the relationship between these two tables and the code that is causing...

It worked fine when I first put that code in and tested it. Then I closed the form and opened it again to test it again, that's when I started having problems. It wouldn't even let me put information in two of the fields that are required in the code (LOEmpID and LOLast). So I get stuck in a...

[surprise] OHHHHHH NOOOOOOOO!!! I put the cancel=true after every if then statement and that made it work great!! Now all of the sudden it won't let me fill out some of the fields (3 of them are in the code for being required or it won't close). The message down on the task bar is: Cannot...

Ok, I changed my code and the first message box is coming up, but then it is closing the form and saving the record. Do I need the Cancel = True after every if statement? Private Sub Form_Unload(Cancel As Integer) Dim strmsg As String If IsNull(LOEmpID) Then MsgBox "Please...

Putting my code in on Unload event procedure helped with one of my other codes, but not with this one. Is it in the code itself? learnasugo

I wrote code to check for blank fields that I want populated, but it doesn't seem to work. Can anyone help me out here? Thanks. Private Sub Form_Close() Dim strmsg As String If IsNull(LOEmpID) Then strmsg = "Please enter your employee ID" ElseIf IsNull(LOLast)...