Recent content by SonicClang

harmankardon, are you still dealing with this issue? I was just reading through this thread. I'm doing something similar to what has been suggested. I've used a separate table (I call it ttTransactions) to store the record ID of the record a user wants to edit. If another user tries opening any...

After you guys said the Macro Designer isn't a replacement for VBA I decided to do what I needed in VBA. I don't think we're going to be doing web apps anytime soon, and it's definitely not needed for my current project. I don't see a SetValue command. Maybe next time I'll try that. Bob, my...

And by "Web" do you mean for SharePoint or internal sites? I was under the impression that Microsoft was trying to push Macros as a replacement for VBA, considering the "Convert Form's Macros to Visual Basic" function doesn't work.

="" didn't work. Access gives me the same error as if I put a space in the value field. This is just an Access database with a front-end for my users. I usually do use VBA to do this stuff but I'm trying to learn. But if it's incapable of doing what I can normally do in VBA, then it's not an...

...is idiotic, dumb, backwards, hardly usable, dumbed down, and I hate it... Having said that, I'm trying to learn to use it because so many of the wizards Access uses now builds macros in the Macro Designer. It will eventually be to my benefit to understand it. I still very much prefer VBA at...

After doing a little reading I think you're right on. The reason I didn't understand what was meant by "audit trail" is because I don't believe that fits this situation. I'm fully aware of what an audit trail is. In fact I'm building in a couple audit trails into this database for when people...

I'm sorry, I don't know what you mean. I must be missing something.

Check out the Instr function http://www.techonthenet.com/access/functions/string/instr.php Possibly? (InStr(1,[City_ST_Zip],",")

I'm designing a database for users to check material in and out of a vault. I'm to the point where I'm creating reports for them to track the materials. I have one report in mind that is just so complicated, it's tying my brain in knots. There are three fields involved here; CSNumber, Parent1...

A form can only have one table or query as its data source. The tab control doesn't actually create more forms on your main form. I think you might want to try sub forms on each tab for what you're trying to do.

I totally agree that most of what this company uses Access for, they could be using Excel. No one here has any idea what a relational database is. In the case I'm talking about right now though, using a database is the correct way to do it. I don't have time now to describe how I've put this...

I've talked with the people who'll be using this database and we've come to the conclusion that we'll just set the fields all to text and forget about automatically calculating. It's pretty disappointing that Access can't store data to the table exactly as it's being displayed on a form. It's...

Trust me, I'd prefer to keep it that way. I'd rather keep people out of the tables 100% of the time. Unfortunately the person who will ultimately be doing reporting on this data insists she needs to use the table directly. In this situation, me making a report and printing it for her wouldn't...

The topic of decimal places seems to come up a lot, which I realized after an extensive use of the Search tool. After reading countless threads on the subject, I'm almost certain this question has never been asked here, or my situation is actually unique. I have a much longer back story of...

By "name" do you mean a person's first name? "Name" is a bad field name to use because it's a reserved word. Do you mean a person's first name? And when you say navigation buttons, do you mean the built-in nav buttons on the form, or buttons you've created to browse records? Have you tried...