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 Rhinorhino 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: jebry
  • Order by date
  1. jebry

    Checking if a record was modified

    Hi zevw! Try using the OnExit procedure of the subform control. It may not run when you click another tab, but it should run when they try to enter the other subform. hth Jeff Bridgham Purdue University Graduate School Data Analyst
  2. jebry

    Error 3043 disk error

    Hi! I recently helped a client with an Access database. After I made the necessary changes we burned a copy of the database to a cd. The next day, when trying to open the database, he received the error 3043. He does have access to the drive that the database is on. Any ideas on what the...
  3. jebry

    Changing caption on command button

    Hi! What is the name of the subform control on the main form? If it is the same as the name of the form in it, then you should probably change it. Note again that the syntax calls for the name of the control, not the name of the subform. If these two things have the same name, Access might get...
  4. jebry

    Changing caption on command button

    Hi! One more thing to check: Forms!frmClientInformation!frmCallAudit.txtStatus = 1 frmCallAudit looks like the name of the form. If so, this should be the name of the subform control on the main form, not the name of the form that you are using as a subform. So, the syntax is...
  5. jebry

    Changing caption on command button

    Hi! Don't forget that a subform is not considered a loaded form in Access. Try getting to the controls through the main form: If Forms("YourMainFormName").YourSubformControlName.Form.txtStatus = 1 then Forms("YourMainFormName").YourSubformControlName.Form.btnNewCourtesyCall.Caption = "Click...
  6. jebry

    Entering data from a button

    Hi Paul! I'm not sure why you are doing it this way, but one possibility would be to declare a form level variable in the general section of your form's code: Dim strControlName as String In the Load event of the form put strControlName = "" Then in the Click event for your text boxes put...
  7. jebry

    Error IF Null

    Hi! Wherever you are doing the division use an IIf like this: IIf(YourDemnominator = 0, 0, YourNominator/YourDenominator) Now any time the denominator is 0 you get 0% hth Jeff Bridgham Purdue University Graduate School Data Analyst
  8. jebry

    Export specific Data from Access to specific cells in Excel VBA

    Hi! Here is some code to get you started: Dim ExcelBook As Excel.Workbook Dim ExcelSheet As Excel.Worksheet Set ExcelBook = Excel.Workbooks.Open(Path to your Excel file) Set ExcelSheet = ExcelBook.Worksheets("Worksheet Name") ExcelSheet.Range(YourCell such as "A1").FormulaR1C1 = Data from...
  9. jebry

    How do you change the sheet name with Excel Automation?

    Yes it does, let's hope it is right! Jeff Bridgham Purdue University Graduate School Data Analyst
  10. jebry

    How do you change the sheet name with Excel Automation?

    Hi! I think it would be like this: Dim objXLSheet As Excel.Worksheet Set objXLSheet = objXLBook.Worksheets("Sheet1") objXLSheet.Name = "FPY & Rework" Note, I haven't actually tried this. Jeff Bridgham Purdue University Graduate School Data Analyst
  11. jebry

    SaveRecord when in Form Add

    Well, one question, what does the save button do? In this situation, I would code it to ask if they are ready to save and, upon confirmation, I would save the record and move to a new record. Taking the user off of the current record might help the problem. If it is appropriate, you can just...
  12. jebry

    Cannot update a form

    Hi! In my experience there are three causes of that error that are most common: 1. Somewhere in your code you misspelled a field name. 2. You designed a query and accidentally left out a field that you thought you added. 3. You misspelled a method after a dot operator (much less common...
  13. jebry

    SaveRecord when in Form Add

    Hi! Not knowing you complete situation one potential solution that would be quick to implement is to add a table that stores the current max id. Then use code to read the id from that table and increment it by one for every new record. That way users can't get the same number even if the record...
  14. jebry

    Updating a field in a table

    Hi! Let me be clearer. You have a main form called frmChaseSummary, you have a subform called frmChaseDetails. To put the subform onto the form, you used a subform control. This control also has a name and it is probably different than the name of the subform. Also, you use a text box control...
  15. jebry

    adding data to an excel spreadsheet

    Hi robojeff! I'll need to see all the code to get an idea of what you are doing. But, in general, if you create an Excel boox using the TransferSpreadsheet method then you have to open the book to do anything with it. It seems that you have opened the book in the code above, but I can't tell...
  16. jebry

    Updating a field in a table

    Hi, there are a few things we need to find out: "SELECT NextChase FROM tblChaseSummary WHERE ChaseSummaryID=" _ & Forms!frmChaseSummary!frmChaseDetails!ChaseSummaryID In the statement above: is NextChase a field in tblChaseSummary? is ChaseSummaryID as field in tblChaseSummary? is...
  17. jebry

    How long to build a db with data clean up added?

    That was my first thought as well! I have been trying to convince her that a new grad would need 18-24 months to do this at least, but she is convinced that I am exagerating and 6 months should be enough. So your vote would be infinite time because the completed project would not be what they...
  18. jebry

    How long to build a db with data clean up added?

    Hi! Here is the situation: I have a friend who is the director of a non-profit organization. She wants to hire someone to build a database from Access that will be used to run all aspects of the organization. She wants LAN based security levels, traking of edits to the data, financial...
  19. jebry

    Client insists on php & MS Access, connect problems

    Our project team does not have a php expert, so a newbie to php has done the programming, we have tried numerous code from various online sites, but to no avail. Does anyone know of a solution for this dilemma? Our current working copy is on a UNIX system, but I believe it will ultimately be...
    • jebry
    • Thread
    • Replies: 2
    • Forum: PHP
  20. jebry

    dependancy of text box visibility

    Hi! Use Conditional Formatting from the Format menu. hth Jeff Bridgham Purdue University Graduate School Data Analyst

Part and Inventory Search

Back
Top