Search results

Here is what I did. I opened the FE, and deleted the linked table Admin. I closed the db, went to the FE for the other BE file, and since they both use the same FE, the Admin table was gone. I then closed the FE. I then opened each BE separately and added the field to the Admin Table. I...

Sorry. Both BE's work as expected if I haven't added the new field to both BE's. Identical field names and types. When I add the new field to both back ends, it only works when I relink the table. Then when I exit that FE, (the same always), and to the renamed BE, (again, the same name that...

That's right. If I open the FE and it works, great. I then open the FE again with the different BE, (but renamed appropriately), it doesn't work. Still in that FE, if I relink that one table, it then works. If I close the FE and open it again with the other BE, (but rename appropriately), it...

Hi DBG, what I tried was I converted the linked table in the FE to a Local Table, renamed it, and then used New Data Source to link the BE table to the FE. No change. Same problem as I described. To me, the fundamental question is by adding a new field why do I have this problem. I also went...

Hi. I built an Access database for myself to help me, (Chuck), manage business projects. I gave a copy to a friend of mine, (Ed), to allow him to do the same with his projects. The database uses a frontend and a backend. As with any database, the more you use it the more you see the need to...

Update: I found a way to make this work. Before I start adding my .Recipients, .Subject, .Body data I added a line, DoCmd.RunCommand acCmdAppMinimize After the end of the email piece, i.e. Set oEmail = Nothing, Set oApp = Nothing, I added, DoCmd.RunCommand acCmdAppRestore. It does what I was...

Hi, I have code that works well from an Access form that takes the data I want and creates a new Outlook email message. The problem I'm having is when the new email message is created, it stays behind Access. Although Windows has a flashing icon on the task bar, it's easy to overlook. What...

Pat, thank you for taking the time to provide feedback. I got around the problem by modifying the query that is used for the report and using the field in the query, and not trying to use a control out of a subreport. I verified that my subreport control was in the footer, yet, the value...

Uncle Gizmo, how do you fix that?

OK, this is driving me nuts. I have a report. The main report has two sub reports. If I run the report with the two sub reports, everything displays correctly. See the screen shot below, highlighted in YELLOW. This is on the second page of a two page report. As a simple first step, if I...

arnelgp, thanks. I had to try a few different vba commands to get it to work. Essentially the DoCmd.Setparameter "p1", "*" resulted in a 2431 error. I got around that by replacing it with, Me.p1 = "*" which worked. Thank you for taking the time to reply. It was helpful.

Minty, There is a Contractor table. It has a list of the contractors, each with their own Autonumber field. The contractor who's name is "All" has an Autonumber value of 1. There is a Job Table. In the Job Table you have a list of things like the amount of the job, a description of the job...

Minty, I wasn't clear on your response. When you said "remove the All", All is one of the Contractor names. It's the value of the AutoNumber field for the contractor by the name of All. Since it is an Autonumber field, it will never be Null.

Hi, I know this has been addressed before but I can't find the solution. I have a form with a ComboBox. The ComboBox drop-down has the name of contractors and the name of "All". "All" has a value of one and each contractor has their own value, like 2, 3, 4 etc. If the value is not equal to...

The_Doc_Man, For What It's Worth, I used the On Format event in the Report Footer, and it worked.

All, thank you. The easy solution was to move my code from On Load to the Format section of a Section. That worked. Thank you! Chuck

Hi, I have a report that has on the "On Load" event some code that makes a text box visible or not based on some criteria. It works perfectly when you open the report using Print Preview. When I click on a Command Button that runs code and then exports the report to a PDF, the .visible doesn't...

Thank you both. I added IIf(DatePart("m",Date())>=7,1,2) to the Default of the Combo Box and it worked. Actually, I had tried that before but I wasn't getting the result I wanted because I goofed. I had >=7,1,2 and it should have been >=7,2,1. Thank you again.

Hi, I have a Combo Box that has as it's Row Source only two choices: 1;"Spring Startup";2;"Winterize" The width of the column widths are 0; 1.5, so you will only see Startup or Winterize I have a Text Box called MonthNbr that has as it's control source: =IIf(DatePart("m",Date())<=7,1,2)...

That took a while. Change text box to Plain Text from Rich Text and then use PlainText to address the field with underlying Rich Text. THANK YOU ALL! SOLVED