Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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