Search results

Hey DOC MAN you are the one! It works, god knows why, but it works!!!! Here is what I found, Code A) works just fine, Code B) crashes. The only deference between A and B is ORDER BY followed by WHERE being swapped.: A) strSql_in = "SELECT * FROM MailRecs where active ORDER BY...

Not sure what you are meaning by aggregate function. everything in the selected are simple fields in the table. As for why DAO once the table is opened the VBA does a huge amount of processing on the table. I could open a query (which I am doing for now but that just litters the project with...

Hi guys, thanks for the quick replies. Yes tried the various ways of putting MailRecs.owneraddr1, also tried making a query in the builder and copying the SQL over. This crashed too, same error message. Very confusing

I have a little code here. If I include the code with the ORDER BY clause I crash with a 3095 error. If I comment the ORDER BY out, and execute the second select command instead everything works. Question, what am I missing. I have tried braces, bracket, parenthesizes you name it nothing...

Did the TempVar trick, works great. Learn something everyday!!

Tied varous things to reference the fields. Here are a few trys: =[rs_code5]![owneraddr1] =Mid([rs_datain]![InputText],17,30) =Mid([RawDataIn]![InputText],107,30) rs_code5 and rs_datain are the DAO links to the tables, RawDataIn is the actual table (one of them).... All give me #Name...

Hey you are ACE! Worked like a charm. Got the window open, but all the fields (That are coming from the VBA code) are showing up as #Name? Not sure why that is. Greg

I have a large loop running, inside this loop, the program needs to stop for operator intervention. (See code below) Once the user and adjusted the data the loop continues on. At least that is how I need it to work. What is happening now is the program completes until the end of the file it...

Interesting. Why would you not do it after every record? Is there a performance issue. or just a visual one?

Not sure if this will help anyone else. I did find my problem. Seems I closed the status bar inside the loop I was counting through. Explains why worked for for iteration 1 but failed on 2.

I have to run through a large (read several hundred thousand records) import file. What I was trying to do is just show the user a progress bar, so they know something is happening, while they wait. I am using this code: Set rs_datain = DBEngine(0)(0).OpenRecordset(strsqlin)...

DCount works like a charm!! Thanks for the suggestion.

I get sent a CSV file every year, or when requested.

Not looking for duplicated persay. What is happening is; I get a new records from the mainframe system. I then have to 'import' these records into my tables. Problem is some of the records might already exist as is, others might exist but have been changed (Treat as new in this case). So...

I am trying to do something like this: IF EXISTS (SELECT 1 FROM Table1 WHERE Column1 = 1) BEGIN -- UPDATE QUERY END ELSE BEGIN -- INSERT QUERY END ENDIF Does this work in Access 2013 VBA? What I need to do is check to see if a hashcode already exists in the database. If it does...

A two step process I have used in these types of situation is a simple Export / Import. There are ways of pooching this method, but less damaging than someone typing in data wrong.

I would like to find a way to execute SQL code on a remote BE server. Most of the code is going to be simple SQL schema maintenance like adding tables, or columns. There might be some creation of views or triggers. The reason for this is simple. A client gets a new version of the software...

Yea was thinking might not be the easiest thing in the world. The reason for the different BE is just to make things a little easier for the end user. Mount the DB on the DB server they already have running. As for the DB just containing tables, not it will contain tables, and Views for...

What I would like to do is code my VBA so that it is as installation independent as possible. Right now the FE is Access 2013, and I would like the BE to be any one of Access 2013, MySQL, Postgresql, SQLServer, Oracle, DB2. Is there a way I can keep 99% of the installation specific code in...

Going through the file, I am trying to find where you created txtRollLinkID. Can not seem to find it on the subform at all.