Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: qwerty70
  • Content: Threads
  • Order by date
  1. qwerty70

    Merge data from more than 1 row

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

    Link Excel to a secured MS Access

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

    Null fields in report

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

    Increment value based on selected category

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

    Disable menu bar title based on user access level

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

    Problem with appending MS Excel data into Access

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

    #Name? appears when printing the report

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

    Populate value

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

    Check box to delete subform's records

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

    Multi-select records in Listbox then copy to subform

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

    Text data type changed when exporting a report to Excel

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

    Report Footer Calculation

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

    Hide Tab Control's page if subform's recordcount is zero

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

    Validate 2 fields to prevent duplicate entry

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

    Highlight record with the highest value

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

    Highlight the record with a highest value

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

    Get the maximum value for text data type

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

    STOP MACRO

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

    How to disable option group button if certain record does not exist

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

    How to detect the email address

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

Part and Inventory Search

Back
Top