Search results

If I save it as .xls, will this remove all the code and macros?

I used to be able to open a link to a spreadsheet in a networked, shared Excel file, without the file actually opening on my desktop. Now, the file wants to open every time I try to create a linked table - but I don't want it to open, because of all the code it goes through. I just need a peek...

@Lightwave: After starting my second major project, and now almost finished, I am still a beginner.

Thanks, J.

Interesting. Try again... Ok, i guess the pdf was too large, didn't see the error. Here's a pic. PCM is a user.

Here is a pdf of a data flow diagram for an inventory control system. This basically shows a user searching for a part, selecting it, and signing it out (for use). Thoughts? Suggestions?

Thanks for the laughs, guys! Doc, I was hoping to hear form you on this, figuring you for a seasoned veteran, and the way you explain things. I am attempting to "Bible" this project right now, as well. I like the whiteboard idea, but I don't have wall space for that. Dave, I am the only one...

How long have you been doing it this way? Is this your profession?

Well, I just read Tony's post in Jon's sticky at the top of this forum...I am definitely a beginner, but I already knew that! So, feeling a bit lost and frustrated here. I am a Lone Ranger on developing several databases for our plant. I took a few intro classes about 10 years ago, and own...

@tfurnivall: Wow, what a great definition of the various levels of abilities. I find my self in a mixture of the levels, definitely not Expert!

Why don't you post your complete database in a zip file? We are going in circles here trying to guess what the root problem is. We need to SEE the objects, relationships, SQL, events, etc. And, while developing or experimenting, you really should rename your controls. Much less confusion as...

Why don't you share a copy of your database, removing any sensitive items. I think we need to see what is happening to understand what you are telling us.

I would love to get out on the water again. Went fishing in the southern Alaskan Islands, had a great time. Currently, just a maintenance guy who spends most the time at work developing Access databases. It get boring sitting in this chair for so long, lol. I hope to move on to another...

Msgbox "Hello", 1 or 2 or 3 gives Yes/No/Cancel which is the same as vbYesNoCancel (which equals 3) The same for 1 or 2

After doing some reading, "Microsoft Access 2013, Programming By Example", Julitta Korol, and some research here, I believe the way to set up an Admin Panel would be to use a logging table in each database and connect to them using DAO or ADO, not sure which is better, yet. Then I could...

"Modern" keyboard? Don't tell me you're from the typewriter era, lol. When I was a kid, I actually saw one and used one. Actually, I think I used one while I was in school for a short time. Doc, I like your tag: "Certified grandpa". My oldest, 17, asked me the other day: Dad, how would you...

Jeez. Solved it...fat finger typo! grrrr...

Hi all. I'm toying around with (trying to) ado connections and here's what I've got: Public Sub OpenDB_ADO() Dim conn As ADODB.Connection Dim strdb As String Stop On Error GoTo ErrHandler strdb = CurrentProject.Path & "\sw101.accdb" Set conn = New...

Very good description, Mark. You are saying that the logical operator then essentially adds the binary values for 1 and 2 producing 0011?

Here is a link to a previous thread, but I think the owner is no longer active. http://http//www.access-programmers.co.uk/forums/showthread.php?p=948955