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: *

  1. qwerty70

    Merge data from more than 1 row

    PHV, any clue how to call this function in Report please. Thank you. Qwerty70
  2. 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...
  3. 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...
  4. qwerty70

    Null fields in report

    Remou, thank you so much. It worked! regards qwerty70
  5. 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...
  6. qwerty70

    Increment value based on selected category

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

    Problem with appending MS Excel data into Access

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

    Problem with appending MS Excel data into Access

    ...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", "myPassword" Please help the novice. Thanks...
  11. qwerty70

    Problem with appending MS Excel data into Access

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

    Problem with appending MS Excel data into Access

    ...the append query that adds all of the records from MyTable 'to the tblCalcSht table. strSQL = "Insert into tblOC_CalcSht Select * from Temp" 'Execute the SQL statement. db.Execute strSQL 'Remove the attached table because it's...
  13. qwerty70

    #Name? appears when printing the report

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

    #Name? appears when printing the report

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

    Populate value

    TheAceman1, thanks a lot. That's exactly what I'm looking for. reqards, qwerty70
  17. 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...
  18. qwerty70

    Check box to delete subform's records

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

    Check box to delete subform's records

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

Part and Inventory Search

Back
Top