Search results for query: *

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...

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...

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...

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...

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...

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...

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...

Dear All, I have a listbox that when I double-click the selected record it copies the information and paste it to my subform. This works fine as per my code below: Private Sub List2_DblClick(Cancel As Integer) If (mbolIsDirty) Then If (MsgBox("Do you want to save the Document...

Dear All, In my report, I have a field called "txtRevNum". When I preview record, it read as "1A". However, once I exported my report to Excel, "1A" becomes "0.0417". I'm just wondering why my text data field suddenly changed to number. Your help is highly appreciated. regards, qwerty70

Dear All, I have a report that shows a wrong calculation once it is printed. When I preview it, the calculation looks perfect. I have 3 unbound textboxes on my report footer, these are: txtTotalDoc, the control source is "=Count([DocNum])" txtCountLatest txtSuperseded, the control source is...

Dear All, I have a bound main form named frmInTransmittal, it has a tab control (TabCtl6) with 5 pages (Pages0 to 4). Each page has their own subforms bound to its respective tables. Each 5 subforms have its own field called "InTrans" that is linked to the mainform's text box called...

Dear All, I have a table "tblDocTrans" and it consist of 2 fields: ContractNum (text) & TransNum (text). In my "frmDocTrans" form, I would like to prevent any Transmittal Number entry if they fall under the same Contract Number. The system should accept the entry as long as the transmittal...

Dear All, My inquiry is relevant to thread702-1381356. In my report, is there any way to highlight a record that contains the highest revision number? As you can see per my sample data below, the revision number field have 2 different value formats; alpha-numeric and number. Therefore, the...

Dear All, My inquiry is relevant to thread702-1381356 of the Access forms. In my report, is there any way to highlight a record that contains the highest revision number? As you can see per my sample data below, the revision number field have 2 different value formats; alpha-numeric and...

Dear All, I have a bound form called "frmDrawings". This form is bound to table "tblDrawings", it has 2 fields: txtDrwgNum and txtRevNum. My table contains the following data: txtDrwgNum txtRevNum 20-SD-2001 1A 20-SD-2001 2F 20-SD-2001 3E What I would like to do in my form is to...

Dear All, I am having a problem dealing with macro. Here's the scenario: If a user logs to my database and has no outstanding task, I want the frmGeneral form to close and return to the main switchboard. The problem occurs when the user opens the frmGeneral again, the system pops up a dialog...

Dear All, I have a main form (frmGeneral) with an option group (optSelect). This option group have 4 radio buttons, these are: OptAll, optER, optIR and optSMP. Purpose of this option group is to filter a record in my main form based on the value of cboSectionID. Assuming, "ER" is not available...

Dear All, I have seen codes for detecting computer name, windows login id, network domain, etc. from different threads. Is there any codes to detect the email address registered in MS Exchange smtp and save it in the table? Purpose of this is to prevent typing the email addresses in the table...