Recent content by Machino

mike60smart The forms are blanked out which is what I wanted but it also blanks out those records that are already there from showing up in the navigation bar at the bottom of each tab. When I select a tab it shows the navigation bar as 1 of 1. Any way to have both things available? Thanks...

Mark Thanks for your comments. I will keep this in mind as I progress developing this database. At the moment the client is doing it all hand. I am trying to help them move to a more automated way of handling this process. Machino

Hi mike60smart I do want users to have the capability to add new staff, customers and vendors. The problem that I am experiencing is that when the form is opened, the user can easily edit the displayed value not knowing that they are affecting a previously saved value. I want them open onto a...

Hi mike60smart The values are now updating properly but the big problem that still remains is that when you open any of the subforms from the tabs they open up with values that a user can accidentally change. I would like them to open to blank fields. Also, to prevent users from adding...

Hi Mike60smart In the process of demonstrating how the database works I discovered a couple of anomalies. When you open any of the other tabs the fields do not initial as blank. Also, I found that all of the new entries made to the underlying tables through the corresponding forms (ie, Clients...

Hi mike60smart I figured out the problem with the print preview. Everything is working fine for now. Thank you very very much for all of your assistance. Take care. Best Machino

Hi mike60smart I removed the PO_ID's you just added because they didn't give the desired results. The Print Report button is supposed to show a printable list of PO's that are still outstanding or not completed. I added a set focus on the find record event procedure which I think is working...

Hi mike60smart Here's the latest DB. The [PO_ID] is in the report. I'm not sure what's going on. Thanks. Machino

This is the code I found in the On click event. Thanks.

Re: Save and create new record Hi mike60smart I see what you have done and it has resolved most of the issues. The only thing that is not working properly is that you select the Print Report button a syntax error message appears (see attached jpeg). Also, do you know why the date function in...

Hi mike60smart Thanks for the updated database and the jpeg with the settings for turning off the side bar. I tried incorporating the changes you made to my more recent file and for some reason I am getting a method error on the PONr. All of the fields have been renamed and configured to...

Hi mike60smart Thank you very much for you suggestions and help. I was able to incorporate a great of comments and make them work. I added a new field in my PO_HISTORY table to address the PO number (PO_NO) while leaving the PO_ID as the primary key. At the moment I have two issues that I...

Hi All I am a newbee (somewhat). I recently created a new database for a client. The problem I am encountering is that I would like to start a new record once I have selected the save button. Once the user starts to fill out the form a PO# is automatically generated. After the user has has...