Recent content by joe789

Hi Folks, I am trying to help a non profit government agency make use of new billing standards and thru this have been introduced to a file format structure dubbed as 'EDI' which differs considerable from any other flat file structure in that the start of each row of data, as indicated by a...

Hey Folks, I am most comfortable, and have more experience, with using MS Access over VB. I would like to try to transform some of the ACCDE files (most all of them use linked SQL tables) I have created into executable stand alone applications with VB and I am wondering if there is any free...

Hi Folks, I am testing a ACCDB/ACCDE that uses linked SQL tables and Access as a front-end; everything works perfectly, however, in the very rare event two or more users try to book a single open appointment at the exact same time, the following error is generated: 'The data has been changed...

Hi Folks, I have a ACCDB/ACCDE that has a few linked SQL tables via a DSNless connection code ran via Autoexec macro. Everything works perfectly fine; however, I noticed that via testing if a form remains open for so long (and I cannot determine how long until it occurs), all the fields on the...

Hi Folks, I am about to roll out a ACCDE to folks that may very well have a different version/update install on their MS Access; and thru the years, I have noticed that every once in a while if a ACCDE has been compiled and the user attempts to use the files on a version that may be not as...

Hi Folks, In a form linked to SQL table with mandatory fields, if someone doesn't enter all the mandatory fields then hits a command button that sends them back to the main form, after closing the input form, a ODBC--call failed error appears stating column does not allow nulls ... is there a...

Hi Folks, I have a command button that essentially opens a form based on a date populated by the user so that any records matching that date will be returned: DoCmd.OpenForm "Scheduling", , , "[Date of Appt] = Forms!FINDSCHEDULING!Text22" & " AND " & "[Agency] = Forms!FINDSCHEDULING!Text46"...

Hi Folks, I have a form that opens via AutoExec with a unbound textbox inside of it set to a default value of '1' that is locked so the user cannot change it. I have a query that runs automatically that places the max version number from a SQL linked table into a table. I am trying to figure...

Hi Folks, I have some code being called from a AutoExec macro. The problem is, that code has some connection strings in it, so if the AutoExec fails, I don't want the traditional 'Macro Single Step' error being flashed on the screen to the user because it has the 'Arguments:' of the code...

Hey Folks, I have a form that uses a multi-select combo box so that whatever the user selects from that combo box they can then 'load' those selections into a memo field. I am trying to figure out how to save these folks some time, so that they only have to use the above method if they wish to...

Hi Folks, I have a unbound combobox on a form that displays about 150 items loaded via a table that is bound to it. I am trying to determine how to be able to essentially extract any item(s) that have been highlighted/selected and create a string, so to speak, with a comma delimiter between...

Hey Folks, I really hope someone can offer some sort of guidance in this issue. I started to write a fairly elaborate Access database, and as I usually do, I make sure it is all how I want it before I then replace the Access based tables with SQL linked tables in order to store all the data on...

Hi Folks, Once a ACCDE is opened, I am trying to figure out how to run a process in which a prompt box asks for a username then once that is entered a prompt box asks for a password then once that is entered if the username and password combination is found in a table the user is granted access...

Hey Folks, I have created quite a few ACCDE files with the front end being MS Access as a ACCDE to compile the code and connection strings hitting the back end of SQL Server ... some of the programs, all single file, are quite elaborate with forms and VBA in the background. Every time I update...

Hi Folks, I have been struggling with a query that should not be this difficult ... it is essentially updating a value based on a inner join ... any help would be greatly appreciated: Table1 LastName FirstName DateOfBirth UniqueID Table2 LastName FirstName DateOfBirth UniqueID Basically, I...