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!

Recent content by qwerty70

  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

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

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

Part and Inventory Search

Back
Top