Search results

I ended up changing my query to this below...I don't think ms access likes [tablename].[fieldname]. sql = "SELECT O.[Name] as TableName, C.[Name] as ColName, T.[Name] as ColType, C.[Length], " & _ "C.[prec], C.[scale], C.[xtype]...

SQL server does not require a semicolon at the end of the statement. this is a passthru query. the error msg is complaining about a missing operator. I tried your suggestion and same error msg.

tried that and same error msg.

I get an error on the last line that says "Syntax error (missing operator) in query expression 'O.Object_ID = C.Object_ID INNER JOIN sys.types As T ON C.System_Type_ID = T.System_Type_I' " Dim db As DAO.Database Dim qODBC As DAO.QueryDef Dim sqODBC As String, sConnectDAO As String Set db =...

I get an error "type mismatch" on this line below: Set rst = CreateObject("ADODB.Recordset") Dim temp As String Dim rst As Recordset Dim db As Database Dim strSQLServer As String Dim strSQLDatabase As String Dim strSQLTableName As String Dim strLinkedTableName...

I have 2 functions which i use to gather and store table and field names in my msaccess app. I have several sql linked tables and I also go to get the table and field names for those as well. I want to get the type and size/precision of my fields and I don't want to pull up the SQL systems...

I have some code that i use to print a report and after the report it goes out to print a tif image with a 3rd part exe. The tif image is being printed across the internet so it could take a few seconds or 2 or 3 minutes...depending on the size of the image. The report has multiple records and...

I found it... subformName.Form.FieldName

That worked! Thank you.

I created an activeX of a calendar on my main form (Form1). I want the calendar to display the date that is in a subform. I cannot get the calendar to reflect the field in the subform. This is what I have in the calendar RowSource: Forms!Form1!Form!frm_Xas_dupK_lst.InvDt_Min (Form1 is the...

I have 2 subforms in a form. The 2 subforms are datasheet forms. I want the user to be able to resize the datasheet subforms to the size they want without going to the design view. Just like it is done on design view where you click on the corner and drag it to the size you want. How can I...

That worked! Thanks so much for your help.

Here you go: "WHERE dbo_tbl_decline_dtl.vnd_nbr In("000029978" or "000082393" or "000096370")"

runtime error happens on this line: DoCmd.OpenQuery "QryLoadDeclineDtlForm", acViewNormal, acEdit

Now it's installed, but now i get a runtime error ('3464') Data type mismatch in criteria expression.

Now I get a compiled error: "Sub or function not defined" for line: ReplaceWhereClause(qdf.SQL, sTemp)

I got an error msg for this line: Dim db As DAO.Database Error msg: "user defined type not defined"

Sorry, I didn't scroll up...got it now...

What do I set the variables (db, qdf) as, before i use them?

Thanks, this is good for a report, but i'm trying to pass the values to a query and it doesn't work when i do it to a query.