Search results

Yeah, you're right. Don't ask me. I'm pretty useless with databases and the boss knows that as well. However, he also knows I know enough to get the job done without getting ridiculously overcharged. Basically, yeah, there is no need to merge the two tables. I've made the boss several forms to...

I've developed a database for a small company but've now encountered a few problems. Initially, I was asked to create a table of customers and a table for business to business trade. However, I was then asked to merge the two tables together. This led to a problem. The primary key was set to...

I was wondering if there is any way to control a user's input in to a form such that data entry does not automatically create a new record. Is there any way to collect all inputs in the text/combo boxes and create the new record only when a button is clicked? Cheers, David.

Geez, thanks for your willingness to help elbweb! I've sent you a PM so I look forward to hearing back from you. Cheers again, David.

Thanks a lot for that mate, and about the use of forms, to be honest, I have little experience with those but at very least know that they are used for end user input and what not. However, the company's a little shabby and the boss is too tight to splash out on a developer as such, and I, with...

Cheers for the response Banana. To be honest with you mate, I have read up on Normalization and the like. I understand how stupid it is to have a field for 'Name' and have spacing in values and inconsistent input, and you're right mate, it is much more problematic!! Hence the reason I'm here...

First off, I've gotta apologise for how totally poor I am with Access. I know very little so please retract your laughter if my methods are completely stupid, haha. Basically, I'm using Access to pretty much automate a medium sized businesses accounts with reports, but on top of that, I'm using...