Search results

No tblRelationships does not have a 1 to 1 relationship with tblGuests for instance John is Married to Sally and they have 3 kids and he has a brother and sister that are coming as well. John Mary Wife John Kid Son John Kid Daughter John Kid Daughter John Bro Brother John Sis...

Okay spikepl -- I did say it with a smile :) and while I do realize that most people that use Access are adhoc programmers I have always encouraged them to do things in a manner that facilitates maintenance and less headaches. Mainly because I have to do this with actual programmers as well...

Hmm Windows 7 with A2013 :) maybe its a new undocumented enhancement :)

Okay that is not actually good data base design -- I have worked with Access but also MySQL, SQL Server, and Oracle and the basics of database design are the same regardless. A database should be designed with the data in mind not its use or application that is what Views and such are for...

Egads no no bind -- if you can do it without binding I applaud you. Binding has its own set of issues and problems :) And while it takes a bit more effort up front to do it this way you have a solution that has no binding bug issues and such and can be much more easily ported to a VB.Net...

Okay I am done :) -- What you gave me works -- I have discontinued beating my head on the proverbial wall that is Microsoft -- I am content with the work around -- if you are not then by all means enjoy delving into the mystery if you do come up with a why then let me know. BTW I used your...

Okay I am utterly amazed -- It works! -- Okay can you explain to me why that works but the following does not? If Shift = acCtrlMask Then If KeyCode = vbKeyX Or KeyCode = vbKeyC Or KeyCode = vbKeyV Then Shift = 0 KeyCode = 0 End If End If If I put a debug stop in the...

Okay so you have an Attachment button on a Form within your Action Bar but you do not know how to add the pop up window to add the file to the Record associated with that Form. Is that correct? If that is correct, before you go coding a whole bunch of things. I am quite certain that someone...

Yep you can -- beat your head on a wall and figure out how Microsoft implemented it -- or you can be done with that stress and simply do it the clean easier way. One of the problems doing it the Microsoft way is that if they change something -- which they do from time to time -- they could...

Well as I have found in all things Microsoft and especially the MS Access / MS Excel VBA areas -- it is best to take it to the roots and do not use any of their fancy add-ons (aka read this as anything that makes the code require Access or Excel to use). As for your particular issue I do tend...

Greetings I am a Senior Software Engineer by trade. I have used many flavors of Visual Basic as well as many version of MS Access and MS Excel. As well as their more robust cousins MySQL and SQL Server. My style of coding when it comes to using VBA is to make it more like a normal Visual...

You are trying to make a web based database application using Access?? That is kind of scary. Have you looked into MySQL much more web base friendly. However trying to address you issue. I do not believe you can do what it is you seem to be trying to do. Here are some possible...

Okay what kind of help do you need?

Well I am all for keeping Mama happy :) as well as teaching others a safer more industrial way of using Access

Okay well if you need any help with the how I will keep an eye on the thread.

Try using a Stored Procedure on the database side that returns a success/fail value to the calling front-end -- or if not viable try having the Stored Procedure set a different value after it was supposed to complete successfully. I do not remember does Access have Try..Catch or error handling...

Looks at Nail in left hand... looks at hammer in right hand... looks at computer on desk. Thinks. Puts nail and hammer down and sits done to work on the problem with the computer. ;) Getting back to the original question. Create the relational tables that you should have to store the data...

1 Question and 1 Suggestion Question: Can you outline the how the tables are built -- Field Name, Field Type, Key, Foreign Key ... that kind of thing. Suggestion: It sounds like you do not have an error checking routine wrapped around your inserts that might go a long way in helping trouble...

Locations Table LocationId As Long <Key> Street As String City As String State As String Trips Table TripId As Long <Key> From As Long <Foreign Key> To As Long <Foreign Key> Okay that should give you the basic structure of what you...

Okay in recordsets like in tables the fieldname is often a constant value and in your case the Index is not so let's say we are working with a recordset that returns FirstName and LastName. If the user chooses to list it as FirstName LastName it could be referenced with the indexes as follows...