Search results
-
V
Case Statement In Access?
I was wondering in the Query department... Is there a way that I could have this.... SELECT dbo_UPR30100HSE.GRWGPRN, dbo_UPR30100HSE.EMPLOYID, dbo_UPR00100HSE.SOCSCNUM, RTrim([LASTNAME])+', '+RTrim([FRSTNAME]) AS Name, dbo_UPR30100HSE.CHEKDATE, (HRSWKD = TotalHrs > 520 THEN "520" ELSE... -
V
Unrecognized database format
Fixed It! I fixed it.... When She double-clicked on the Access 2000 database or a shortcut that points to an Access 2000 database or database object, Access 97 starts instead of Access 2000. So I... Create a shortcut that includes the path to the version of Access and the database that you... -
V
Unrecognized database format
Here is my problem. On an End Users Computer they try to open a MSAccess Database and it gives them an ERROR saying... "Unrecognized database format." So I also tried opening up the same database and I got in. Can someone help me on this? We are both using Access 2000. John- -
V
Popup Message when accessing a Report.
I have this monster query with 13 tables. Most of them are small. I am trying to call a report from VBA and I always have something pop up and say with an input box "dbo_UPR00500MBR.EMPLOYID" and so I enter in 1 employee number and it still comes up with everyone else that I didn't need... -
V
Subform selection
David... I am sorry for getting you upset. I apologize for my words. Please except my apology. John- -
V
Subform selection
Why? What is the big deal if I post twice in different discussions? Does it confuse you? John- -
V
Subform selection
I am trying to grab all the data that the enduser selects in the subform. What I have them to do is click on the left-hand side of the subform and make multiple selections. Then what they would do is click on a button that is on the form. How can I find out what the selected data is? Does... -
V
IIF() #ERROR
On this report, which gives a list of checks that were run on a certain day. On this report I need to have a mark by the checks that were voided out. I tried using IIF statement on the control source on the text field. =IIf([VOIDED]>0,"*"," ") Example Output: * 986365 John 65.60 * 986957... -
V
Landscape..Reports...
How can you get your Access reports to be printed Landscape vs. the regular print? Is it in the properties or something like that? John- -
V
Query Problems 'UNION'
I am getting this error: Syntax Error (missing operator) in query expression *-- = Start of the expression --* = End of the expression PARAMETERS [Begin Date] DateTime, [End Date] DateTime; SELECT dbo_BIBUDINFO.DEPARTMNT, dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT... -
V
Insert Query..Invalid Operation
I figured out my problem.. Thanks for all your help! -
V
Insert Query..Invalid Operation
Ok. I changed it and I still get the message. sSql = "INSERT INTO FIXASSET (BARCODE, [ITEM NOTE], CATEGORY, [G-CODE], [EMP#], MFLAG )" & _ " VALUES ('" & strBarcode(i) & "', '" & strItemNote(i) & "', '" & strCategory(i) & "', '" & strGCode(i) & "', " & sEmpNum & ", '-1')"... -
V
Insert Query..Invalid Operation
This is my query and I am not sure why it is calling an invalid operation... ----CODE-------------- Dim sSql As String Dim sFName As String Dim sLName As String Dim sEmpNum As String Dim db As DAO.Database Dim wks As Workspace Dim tblDef As TableDef Dim rst As DAO.Recordset i = 0... -
V
Parameters
This there a way to pass parameters from a Visual Basic Program to an Access report that needs parameters for the query without having the inbox show up?