Search results

I'm trying to insert a '0' into my table named [tbl_RIF-App Info]. The code works in debug mode just fine but when I run it outside of debug, the '0' does not get inserted. Even stranger, if I run a compact and repair and then run my code without debug mode, the '0' gets inserted?? I can't...

My database works just fine on my hard drive but when I go to run it on the server, I receive the error: 'ActiveX Component Can't Create Object' Here's the line of code that triggers the error: Set appWord = GetObject(, "Word.Application") Any suggestions for this? I don't own the...

I'd like to create a Do While loop to help make my code a lot thinner. Below is the code I'm working with now. I currently have App1 - App90 and it continues to grow. I'd like to perform a Do While loop but I'm not sure how to accomplish this. App1 - 90 are all string values. If...

I'm trying to pass a variable in an If statement within a recordset. If I explicitly enter the variable value, the code works fine. I've tried several variations to try and properly reference the variable 'App1'. Here's my latest snippet of code that shows my problem: With rst If...

I'm trying to update a table value based on another value in the same table. Here's the scenario: In the table I have 3 estimate descriptions: Sizing, Planning and Commitment. Each description is tied to a series of numbers representing estimates across different teams. For example...

I'm using .AddNew to add 3 new records to my table (which it does perfectly). After I add these 3 records, I want to run an update on one field using DoCmd.RunSQL. When I run this though, I get '0 records updated'. It will not allow me to update these records right after I've added them. I'm...