Search results for query: *

That worked! I figured it had something to do with the joins, but wasn't sure exactly how to fix it. Thank you so much!!

Basically, I am attempting to combine 2 queries into one. To simplify it, I have a customer table, a Sales table, and a Refund table (whose structure matches the Sales table). I need to report an aggregate by month, returning the following format: Month Cust ID Cust Name Sales Refunds...

I have a form within a table and it's been requested that if a certain selection is made from a combo box in the form then another combo box will become visible. The way the asp page is coded (by someone else prior) I'd prefer not to have to submit the form and display it again. I'm not sure...

I have an Access database that has several SQL Server tables linked (though not used in any queries..instead I use pass-through queries). I am trying to create a report where the recordsource is a nested query where one of these pass through queries is used. Whenever I try to do anything...

I figured out my issue. It was not the characters passed through but the length of the string. Only 64 Characters are allowed and with my adding 'Count' at the end made it more than 64. I will have to add Count later on in my process. Thanks guys.

I am dynamically creating a table where the field names will change everytime the code is ran. My issue is there are several times where the name passed through will contain the '%' character (and possibly other harmful characters). This causes my code to error out. I would prefer not to have...

That helped a lot. I was able to do what I needed. Thank you very much!

I have emails that come in with standardized subject lines and standard formatted bodies. I need to take the information from the email(date, from, subject, and specific data from the body) and enter it into specific columns within an Access database. Not sure if I would have to do this in...

Scriverb, THANKS!! The thread you pointed me to did the trick. I had to break my string up into separate lines because it wasn't wrapping around but I can live with that. This is most helpful and I gave you a star for pointing me in the right direction. Much appreciated.

I have several text boxes on a report that are made up of concatinated fields and strings but in the middle of this I need 1 word to be bold & underlined. Everything I've tried has left the word in the same format as the rest of the main text box. I need to find a way to make just this one...

I've looked at Excel help..it shows the arguments, but not the formula.

I need to convert an Excel Spreedsheet that uses the CumiPmnt() Function into a report in an Access 2000. As far as I can tell there is no way to do this. Basically the calculation is used to determine the finance charges on a loan using the actuarial method, which as I can tell also is about...

I have an Excel spreadsheet in which every field is formatted as Text except 1 Currency & 1 number field. I've automated the importing of the spreadsheet using the .TransferSpreadsheet code. Occasionally, I get a Numeric Overflow error. For some reason, Access 2000 doesn't give any Import...

I've fixed it. I'm not real big on using the chr() function. Usually when you have to use double quotes you can use ' instead which is what I did & it worked. CurrentDb.Execute "UPDATE " & LotTable & " " & _ "SET " & LotTable & ".DBM =...

Okay, I've changed to use a variable for table name which helps readability. Access adds the space around the slashes (I've tried to delete & when I move away from that line Access adds the spaces). In the lines above the error I increase the field size to 10 & in so doing also make sure all...

I'm using Access 2000 & am trying to automate a process for another person. I'm getting a type mismatch where I indicate below. The next line of similar code runs fun, but for some reason it doesn't like that one line of code. I've tried Dim a string variable & putting it all in there & then...

OK, my bad. I didn't have my library database referenced as a "library" in my test database. That would help when I tried to call the procedure. I really need a good slap across the face to wake my brain up. I'm not sure I need to do #1 quite yet, but I'm sure it will come in...

I appreciate the responses. Forgive me, FancyPrairie, but it's Friday & for some reason half my brain is still home in bed sleeping. I'm not quite understanding everything you stated above. I've already started a "library" database (though I haven't implemented it's use yet, still...

Okay, I'm in an multi-user enviroment & most of the time they use multiple databases. The frontend of the database has to reside in a specific path on the users machine depending on what type of machine the user signs in on (which I can obtain by getting the username from the system). I've...

Sue, With regards to your comment above: "many of the reports share the same query, but often the criteria for various reports cannot be combined in the same query": I had a similiar problem. In my database I have reports that, based on whose pulling it: individual rep, manager...