Search results

So sorry! I did not see this post. I wasn't aware of the Code Tags. No need to be rude with Large Red Font. I guess trying to help other people on this forum is not encouraged. I can leave.

I wrote a code to create a backup file when the user exits the program. I have that on my Main Menu. It works beautifully. I have experienced lost data and corruption with databases in the past and I don't have access to our server to create an auto backup nightly. I know I will end up with...

Thank you for the great advise. I figured this out. I always get confused on the "Me." usage. Your description is very helpful.

I'm in the same boat - back to school at 53. Yikes!

Thank you to everyone who gave me input. I have a lot of possibilities here. For now, I'm going to use the After_Update code until I get password protection set up. You are awesome folks!

Aha! You put your finger on my problem. CustomerName is NOT an integer. Thank you!

No, the customer can't change their name, but I am surprised how often we have to update a customer's name in our database. I guess businesses are sold frequently. I like your method. I do have a table of users, but have not initiated a login process yet. I was copying the one from...

So I thought I'd try having any change to the field trigger a message box and confirmation (surprising how many customers change their name these days). But I keep getting an error. Can someone help me? Code Tags Added by UG Please use Code Tags when posting VBA Code Please feel free to...

I agree. That would be the simplest solution. I just haven't done that kind of programming yet. Not sure how to accomplish that. I'm still in the learning phase. I'll have to do more research on how to write that kind of code.

Now that I'm thinking this through, I'm wondering if I make a separate form that is a view only for information, and have a Add/Edit form that is password protected that only authorized employees can change. Thoughts?

Exactly! I don't want the changes to become annoying to the user, but I have two employees that constantly delete the field, not realizing that they are doing it. It becomes frustrating to other employees who have to search for the record, but find that the field is blank. Ugh! That is why I...

Hi all, I have an on going issue. I have some users who use two screens and occasionally will forget where their cursors are and accidentally change data or delete in a field. What is the best way to address this? I think adding a message script on the fields, asking if you want to change or...

Hi All, I have had some really good success writing a comprehensive ERP system for my company. I really enjoyed doing it and would like to learn more and possibly become certified. Any suggestions on a good online school or certification program? Thanks for all the help on here! Heidi

Thank you for your input. I know this looks so weird. But the company I work for does not do anything "normal". I'm having trouble convincing them to move from paper and pencil to manage production and sales. (The owners are in their 60s). Their moto is "That's the way we've always done...

I really don't want to push. I know everyone on here is super busy with their own work. But can I get some eyes on my report. I need to present the finished database to my company at the end of June. I don't like to wait until the last minute with projects. I'm a nerd like that. Thank...

Here is a sample of the database. The original is quite complex at this point. But maybe you can see what is going on with my report.

Hi All, I have a report that I need to create based on data that is entered in my database. I need to total mold counts by day, and then total for the week and give an average mold count per day (as in the Excel example). But then I need it sorted in columns by 4 different customers (CUSTID)...

That was the ticket! Thank you!

I have a report that I want data to display very specifically. I want my part name and revision level to show on the report, but if the revision level is blank, to display only the part name. This is what I have in an unbound text field on the report: =[PartName] & IIf([RevLevel]=" "," ","...

Ok. I need help. Here is what I have: Private Sub TicketID_Click() DoCmd.SearchForRecord , "subTktSchedule2", acFirst, "TicketID= " & Me.TicketID End Sub My TicketID is in subOpenOrders form and I want to open the record in subTktSchedule form. Both are sub forms on frmScheduleTicket...