Recent content by melvis

Hi all, Just looking for a bit of advice really. I'm building my dad a database for his garage so he can store customers details, MOT test details, job details. Where I'm getting confused is displaying this information in a form. Basically, I want there to be one form that shows (without...

Hi all, I've looked through the previous posts here but can't find what I'm looking for (probably because I can't think of how to phrase it). Basically I've got a text box that allows for entry of the item cost, then a text box called Quantity and another text box that calculates the total cost...

Hi Brian, Thanks for the response, it keeps asking me for a parameter though. Any other suggestions? Cheers

Hi all, I've searched the forums but can't seem to find anything similar. I work for social services and we have a database that stores information on children who may need services from adults when they reach 18. What I need to do is create a query (so that a report can be run) that will show...

Hi guys, Thanks for the examples, I'll have a go and see what happens. Cheers

Thanks oldsoftboss, but I can't seem to open any other databases for some reason. I keep getting unrecognised database format.

Hi John, It won't let me open the database, its saying unrecognised database format. Do you know where I can find this for Access97? Sorry, I should have said what version I was using. melvis

Hi all, I've got a form in my database that enables you to print or view reports, which I inherited. There is a list box that is automatically populated with all of the reports listed in the Reports tab of the database window. The list box row source says the following: SELECT msysobjects.Name...

Ahh! The login form checks against the details stored in the table and then displays the selection screen based on the code situated in the onload event. It's only a small database that will used by about 6 people so the security is not too advanced. Should I have a hidden field somewhere in...

I store the user level in the users table, along with their name and login details.

Hi all, I have a frmUserLoginScreen that opens frmMainSelectionScreen, which has 4 command buttons on it. Dependant on user level, some of the command buttons are disabled. I have four user groups, manager, admin, IT and guest. When the guest logs on, the frmMainSelectionScreen only has one...

Hi all, Thanks to a AWF member last week, I have managed to advance a lot further with the login screen I need but have hit a brick wall. Below is the code I was given and at present, the code opens up the same form which is fine, but I need the form that opens to enable the delete client...

Hi Bruce, Thanks for your help, I'll try that out as soon as I can. At the moment, everytime I try and save the changes to the form I'm getting an array of messages like: save operation failed or couldn't update currently locked to memory messages. Have no idea what's going on so I think I'm...

Thankyou, thankyou, thankyou!!!! You've made a bad day a lot better, thanks! Just one more quick question if could be so bold. When I close the splash screen down, the login screen appears (which is fine), but the password is still displayed (masked with ***'s though). Is there anyway to...

Thanks for replying ghudson, I've never posted code before so thanks for the tip. I'm still having the same problem as before though, when I open the form and pick a UserName from the combobox and then enter the password, it pops up with the incorrect password msgbox. My original table has 4...