Search results

I will try and be as brief but as descriptive as possible. I am writing a DB for my friends and I to use for our fantasy hockey league. All the tables and calculations are done. I am not designing forms, but this is where I get stuck. I get daily stats which I format in excel and import to...

I have a form with mostly combo and tect boxes. Most texboxes sahre a common naming convention for example PREVGP1, PREVGP2....... I wrote a for next loop that will look for textboxes that begin with PREVGP for exmaple so here's what I have, what I believe to be write but obviously is not...

I am writing a query in my DB. First I take two values from a table and divide them by each other. Based on the sum a certain value will be added to another column depending on the value range this new value falls between. Here's where it gets tricky for me. If both of the original 2...

Ken, Thanks for all your help. I have one more thing I am attempting to do that eludes me. I have my DB, tables and queries and forms, oh my! I have a linked table to an excel spreadsheet. I change the information on the spreadsheet once a week. I am attempting to query the information...

Im Ok I'm working OK now. I remembered how to do it. if rs.fields.item("Sales Person")=rs2.fields.item("Sales Person") then code here else code here end if

just remembered if recordset.fields.item ([Sales Person]) = "jon smith" then sound about right?

error Method or Data Member not found I seem to remember something like. if recordset.????.field="Jon Smith then code end if does that make any sense?

Been a while since I coded. Can someone help me with: I am coding a button to check a particular field on a table. I have my connection and recordset in place. sp is the variable for my recordset for my table. The field on the table is Sales Person. I am starting from the first recod...

Thanks and 2 ?'s I'll try that coding and thanks. 1. What does the coding "(0) (0)" do after setting db = dbEngine 2.In the While Not loop you say while not bof or eof. Technically you movefirst when entering the loop making it BOF, wouldn't that cut the first record out?

Good idea but.... I like that idea, but a couple of quetions from there. I have a one table with all the data. I understand how the report will simply have whatever data the query has, but how do you create one query that requeries 65 times. Is that where the VB comes in. Also, I'm not...

I'm clear but still unsure What you said makes perfect sense as to what the issue may be. However, what I am unclear of is how I get 65 different reports emailed to 65 different email addresses with one click of a button without using VBA. I am familiar with VBA, but surely there must be a...

I have seen other people out there with this issue and the answer generally is why do you even need that many macros. I think my situation is different so allow me to explain: I am in the IT dept for a car manufacturer. We have 65 dealers associated with us. Each week I pull an excel...