Search results for query: *

I'm running an append query to add ONE record to a table (autonumber primary key). On the mainform (form A), there's a button to open another form (form B), which is what the append query is running off of. Some of the fields in form B are automatically filled with info from form A. Here's my...

Hi gol4, Yep, we tried that one...I guess I can look at again to make sure. Does anyone know which specific reference the format function uses?

Hey guys, I've asked this question before, but need to ask it again b/c of some changes. I made a database in 97 and now I have to convert it to Office/Access XP. In my query, the user enters a report start date in the form mm/dd/yyyy (can be ANY date). What I need to do, is pull records from...

Well, I figured it out myself. In my button, "on click", requery the subform. Bingo!

Hey guys, I have a main form in which the user inputs 2 things: a text box (user enters date) and a combo box (picks a name). My subform needs to pull the matching records, according to what the user inputed in these two controls. The subform isn't working/linking. I tried a button that runs...

Thanks grnzbra, but the NZ function isn't working either: this is what I had: =IIf(NZ([Credit Exp @100%]),"0",[Credit Exp @100%]) I'm still getting #error in the [Credit Exp @100%] field in my report... Any other suggestions?

Hi, I'm adding 2 fields in a report. The fields are "blank", or empty strings, if there is no calculation done for that record (complicated queries behind it). If one of the two fields is "blank", then the sum is also blank, when it should really return the value of the...

Hi guys, Thank you all so much for your help! I tried the methods y'all suggested and Steve's works very nicely. The user enters any date in the format ##/##/##. I use the "day" the user enters in other queries, but only the month is important in this one. The dateadd function had a...

Hi, I have a follow up on a question I posted a few weeks ago. What I'm trying to do is find all the records that are >= minus one month from a user entered date. My data goes starts at 1/1/02 and goes through 12/1/03. FYI, the field "BeginDate" always starts on the 1st of the month...

Thanks Mark. I tried that and it worked. BUT, now I'm getting another error message that says, "Variable not defined" and it highlights "CurrentProject". How do I define this? I'm new to this... :)

Hi, I'm having trouble with the following code. The error message is, "User defined type is not defined." I don't know what's wrong with my code...Any help is appreciated! :) Private Sub Command0_Click() Dim Conn2 As ADODB.Connection Dim Rs1 As ADODB.Recordset Dim...

Update: I got the query only method working, but still curious about the code method. :)

oops meant to say "How do I use the hidden dates method?"

Thanks for the quick response. :) I'm do I do the hidden dates method you mentioned? Also, don't user inputs have to like: [enter date], for example? Thanks, Shivani

Hi, I need to pull records that are >= User Inputted Date - 1 month. My query keeps giving me the error message "Expression is typed incorrectly or is too complex to be evaluated. How do I do this calculation? Thanks in advance! :) Shivani

DougP, I thought of a few more questions...Would I be able to append to a temporary table in the For Next loop? Do I do this by running my query off of this temp. table? Do I have to define these fields somewhere? And where do these fields exist?: Rs1!yourfield = somevalue...

Thank you! I'll try it out. :)

Hi, I fairly new to Access. I'm making a database that requires some complex calculations, along with some queries. My goal to make 1 report and use VBA to do all the calculations. I only know very basic VBA though. I'd like to run a query to find certain records from my table and then cycle...

Hi Mike, Thanks for the speedy response. I'll try it out. =) Shivani

Hi, I just discovered this site today! It's wonderful. :) I'm making a database at work and need help with a query. I'm trying to pull records within a date range: (user inputed date till the of the year). Is there an easy way to do this? Thanks in advance!