Search results

Thank you Leigh for both of your suggestions. I added the 'New' to the syntax of ADODB connection and it resolved that particular error message. I am still having problems with the syntax on the SQL portion of the recordset. I did try boyd's suggestion earlier I used both in his post for the...

Thanks for the update. I appreciate it. I can't say I understand why, but it looks like I resolved that error at hand. Now I'm getting another error: Run-time error '-2147217904 (80040e10)': No value given for one or more required parameters. Any idea what that might be about?

No other suggestions out there???? Help!!!!!!

Thanks for the suggestion. I tried option 1 and it has gotten rid of my syntax error. Now I'm getting: Run-time error '91': "Object variable or With block variable not set" When I Debug, it highlights the section of code that reads: myRecordSet.ActiveConnection = cnn1 Any suggestions...

I am trying to implement a password protected timecard database and I am having a hard time validating the user and PIN Number on the clock in form. I have a table (Employee) containing Social Sec. Number (SSN, PK) and Pin number (PersonalPIN). Within my form, on the afterupdate portion of the...

Looks like it was the 24 hour figure that needed to be added. Works perfectly. Thanks again

I have a table that I want to use for a time clock. There are 6 columns: EmployeeID Date ArriveTime LunchOut LunchIn DepartTime The PK is made up of EmployeeID and Date. My question is kind of two-fold. 1) What datatype should I set the time fields so that I can run a query to add up the...

Not using an UPDATE query because I couldn't figure out how to pass through a limiting statement like in a select statement (SELECT TOP XXX) This is an important user component to updating the recordsets. pbaldy and boblarson, you guys are always answering my stuff. You're great.

I got it to work on my own. Yeah, finally I figured one out. Can I get credit for answering my own question? Private Sub CountGroup_AfterUpdate() Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnn1 Dim...

Here's what I have now. I think I'm on the right track, but I think my update part where I need to update field 3 is not working right. I get an error that says "Compile error: Invalid use of property" The part of code that is highlighted is ".Fields(3) =" Private Sub...

I have a recordset I want to update with some values derived from control on a form. here is what I have so far: Private Sub CountGroup_AfterUpdate() Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnn1...

Lots of readers, no takers on this one? I'm a little at a loss.

Hmmmm. how about if the SQL statement is an UPDATE statement instead of just a SELECT? BTW, what's the difference between using Docmd.runsql and Currentdb.....?

I figured that would be the case. Any idea on syntax specifically for the part I want to be dynamic? Place the VBA on the form, right? Not called from a module?

I have a query that I'd like to limit the results to. I've been able to find out that the syntax is SELECT TOP 20 or SELECT TOP 100, but my question is what do I do when I would like my top number to be a dynamic number that I put into a text box on a form? Anyone help on that one?

Not sure if this needs to go in queries or in Modules & VBA. I have an inventory database that tracks inventory for 8 online trading partners. Each trading partner has an inventory account where various transactions are entered in order to arrive at an account balance (onhand inventory)...

Permissions on file are fine. I checked all of that. I actually have another query similar to this one that uses data from more than 1 table. That query also has the same problem. So, for some reason, I think its on queries that are comprised of more than 1 table. I don't know enough about...

Certainly seems like a viable solution. Since I'm not extremely VBA savvy, I was hoping for my less complicated solution to work. if I can't get mine to work I'll try this. does anyone else know why my query would have difficulty exporting? Its almost like there is something wrong with the...

I have a query drawing its data from two tables. The two tables are related through Item number. One table contains item data, the other contains transactions for individual items on the item table. Here is the SQL: SELECT "3253" AS 3253, CS_Transactions.Item...

You got it! This is exactly what I needed. Thanks for the help.