Search results

This is more of a direct support question to Microsoft, but obviously that's not going anywhere, and I couldn't find any answers on Google. So if anyone else has come across this.... Got my database ready to be packaged and I downloaded the 'Microsoft Access 2010 Runtime' package to help make...

Anyone know a trick / tool or plug-in that'll allow you to change characters in the names of multiple fields (kind of like a 'Find & Replace' for Field Names)?

I'm trying to figure out the code for duplicating a record and having a textbox (that keeps track of the revisions for that record) increase it's number counter up automatically. I used the macro for creating a command button for duplicate record, but when I converted it using Access 2010's...

Tried it, but nothing different happens

I have some long code which I'm attempting to simplify through variables, but I'm not achieving success. Here's the original code; Dim Cameras As String If Me.cmb1stCamACam & Me.cmb1stCamBCam <> 0 Then If Me.cmb1stCamACam = Me.cmb1stCamBCam Then Cameras = "2 x " &...

Thanks, my stupidity is now fading...for the time being...

Again, sorry for my idiocy, but txtProject should be bound to what? Feel free to correct the Syntax of my current statement.

Jeez, I've gotten so spoiled using the macros for simply opening a form, I'm now having problems simply writing it into VBA (Access's "convert macro to VBA" button doesn't work very well)?! Okay, this should be really simple but my syntax for SQL and opening code isn't tops. Here's the info...

Here’s what I’ve got and what I’m trying to accomplish; Group 1___Group 2____Group 3___Group 4 Sony______ Panasonic ___N/A _________N/A Sony______N/A__________N/A_________N/A N/A_______Sony_________N/A_________N/A Nikon______Sony_________Panasonic____N/A N/A_______Sony_________Nikon________N/A...

Thanks for the welcome! So here's the current problem scenarios I'm having with your suggestion, and feel free to let me know exactly where I'm going wrong. All scenarios have three tables, similar structure to my initial post; SCENARIO 1 - NO LOOKUP FIELDS tblCamera...

Ahhhh....I see the logic in that. I'll give it a shot when I get a chance today.

Hi Guys, New to the forum and semi-new to Access (programmed intermediate level a decade ago). So my database is setup using lookup columns extensively, which as I've read in many different posts in this and other forums is genuinely looked down upon (I too have come across the '8 evils of...