Search results for query: *

PHV, any clue how to call this function in Report please. Thank you. Qwerty70

Dear All, In my Query1, I have the following data: IsoLbl Comp2 Stencil PBBCA-PR-16223.01 ELBOW GK14 PBBCA-PR-16223.01 ELBOW GK24 PBBCA-PR-16223.01 ELBOW GK50 PBBCA-PR-16223.01 ELBOW GK55 PBBCA-PR-16223.01 FLANGE GK27 PBBCA-PR-16223.01 FLANGE GK28 In the IsoLbl field as you can see...

I have read the Tek-Tips' faq68-1403 concerning linking of MS Excel workbook to MS Access. This is great. Is there any way to link the Excel workbook to Access query that bypasses the security workgroup. I tried to link my Excel workbook to my secured Access database but it is always asking me...

Remou, thank you so much. It worked! regards qwerty70

Please help the novice. My rptVisa report has 3 bound fields: Date1 Date2 Date3 Date4 Also, I have created a unbound field called txtExpiry. Here's the scenario: If Date1, Date2, Date3 & Date4 fields are not null, then today's date minus Date4 and the result should appear in txtExpiry (this...

KenReay, Thanks for the prompt reply. Is there any other way beside from creating another table? If no, then I would try your suggestion and let you know. Thanks, qwerty70

My mainform frmEmployee is linked to a tblEmployee, and have 2 controls: 1) EmpNum (textbox) 2) Category (combo box). List values are 'Employee' and 'Guest'. Within the frmEmployee, there are also 2 hidden subforms (fsubEmp & fsubGU) each connected in their own source query. Each query has...

I have a customized menu bar called "Forms". Under this menu, there are different titles underneath it and one of them is called "General". What I would like to happen here is, if a 'read-only' user logs on, the menu title "General" should be disabled. If I log on as an Administrator the...

JerryKlmns, a million thanks to you. It worked!!! I really appreciate your time and effort in sorting this out. A star for you. Only a slight typo...i just removed the extra double quote on the dbe.SystemDB = .... line. Best Regards, qwerty70

Has this something to do with ODBC driver? I got this piece of code from the internet but I don't know how to insert this into my existing code. Conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=c:\somepath\mydb.mdb;" & _ "SystemDB=c:\somepath\mydb.mdw;", _ "myUsername"...

JerryKlmns, Thanks for your prompt reply. Yes, TDCSK.mdb is joined to a workgroup called MySystem.mdw which also is located in the same folder. Thanks, qwerty70

Dear All, I have a problem appending my Excel data into our database that is stored in our server. When I hit the command button on my Excel sheet, I get this error: Run-time error '3033': You do not have the necessary permissions to use the 'H:\206_PDDM\TDC_DB\TDCSK.mdb' object. Have your...

PHV & TheAceman1, thank you. Both solutions solved my problem. Appreciate your help. Regards, qwerty70

PHV, frmVenDocEntry is closed when I print the report. Here's the code behind the cmdReport button on my frmVenDocEntry form: Private Sub cmdReport_Click() On Error GoTo Err_cmdReport_Click Dim stDocName As String stDocName = "rptVenDoc" 'Check values are entered into Date...

I have a form that has a date parameter prior to printing a report. Whenever I preview the report, the date range that I supplied appears in my report without any problem, i.e. "Data entry from 9/1/07 to 12/1/07", but when I print the report an error "#Name?" appears in the print-out. Here's...

TheAceman1, thanks a lot. That's exactly what I'm looking for. reqards, qwerty70

Dear All, My frmDrawing is bound to a table called tblDrawing. frmDrawing have 2 fields, txtDwgNum and txtDescription. txtDwgNum is indexed and accepts duplicate entry. What I would like to happen is, if I enter any drawing number that is already existing in the tblDrawing, I want the...

PHV, thanks. That worked perfect. My apology for late feedback, I was on leave. I really appreciate your continuous support. A star for you. Regards, qwerty70

PHV, RequestID in subIssue is linked to RequestID in the mainform. Here's the RecordSource of subIssue: SELECT [tblIssue].[RequestID], [tblIssue].[SerialNum], [tblIssue].[Brand], [tblIssue].[Model], [tblIssue].[Sticker], [tblIssue].[ID] FROM [tblIssue] Thanks, qwerty70

Dear All, My main form "frmRequestMaster" has a check box named "Demobilized" and once I click it I want my subform's (subIssue) records to be deleted. Here's my code but I just can't make it work, please help. Private Sub Demobilized_AfterUpdate() If Me.Demobilized = True Then...