Search results

Hi Folks, I am struggling with trying to create a query. I have a normalized base table that contains a unique identifier for each person, a date of service, and a unique procedure rendered on that date of service. I have the data sorted by unique identifier, date of service, and procedure...

Hi Folks, Just wondering if it is possible to somehow embed the ODBC connection string into a MS Access table so as to link the table to SQL Server without relying on setting up a ODBC connection on that machine? Thanks, Joe

Hi Folks, I am attempting to estimate a proposed benefit plan limitation of service units accruals for a government non-profit health care system. Certain procedures have certain proposed limitations as to how much service units an individual can receive in a given period of time. I am...

Hi Folks, Just wondering if there is a easy way to send out out automatically generated e-mail contingent on results in queries. For instance, I have automated a process that loads some data every week and then several hours later some code automatically loads some other data, after all the...

Hey Folks, I am getting a 'The command or action 'Quit' isn't available now' error when attempting to quitacess via macro or code. At times the quit function will work then as soon as it displays the error above, with absolutely no difference between working or error state at all, it will not...

Hi Folks, Any help would be greatly appreciated. Example of data in a single field: CLP*102861#3299003*1*42.66*42.66*0*MC*000000141450*53 Is there a way to make a query so that everything between the * and next * gets into its own field; for example: Field1: CLP Field2: 102861#3299003...

Hi Folks, I am, unfortunately, working on a massive nasty huge cluttered mess of a flat file for a local government agencies compliance with new billing standards. Any help or suggestions would be greatly appreciated. After analyzing the nebulous and arduous task that lies ahead of me, I only...

Hi Folks, I am trying to run this in access and if need be, can try to run it in SQL query analyzer. I am talking about 2 million records right now, and I got that down from twice that many. I have a normalized listing of unique identifier and unique date of service. I am trying to write a...

Hi Folks, If this is easily possible, it would be awesome and would really help me a lot ... this is for non-profit government agency. If I have several tables, one of which is a base table that has a unique primary key and header information (36 clients = 36 unique rows of information). This...

I have a data-entry program that uses access as a front-end and SQL Server as the back-end via a linked table that uses ODBC specified on my machine ... the program and forms and everything works well; but thinking ahead, if I want to give this program to someone who does not have an ODBC for...

I figured it out ... I just disabled the menu bar completely along with the above mentioned disables and now the data entry user can truly do nothing at all except enter data exactly as needs be and completely ... awesome it is menubar = '=1' without the quotes in the properties section of the...

Hi Folks, I have a database where pretty much everything I know how to disable has been disabled so that the user cannot enter duplicates, cannot alter data once entered, cannot delete data already entered, cannot close out the form to get to the code, tables, or design view, password protected...

Hi Folks, If someone enters duplicate data the following error is rendered: "Microsoft Office Access: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that...

Hi Folks, Over the last 10+ years I have created a host of Microsoft Access programs, most of them requiring users to input data into forms as a means of data collection ... some of the forms use drop down boxes, list boxes, codes to check for errors, macro kick offs, input masking, and what...

The only reason I have to do it like this is because the users who will use this program are not computer literate and don't want to have to do any extra steps and are very prone to making errors ... so this way, I have a dozen listboxes that force the user to click on what they want and a GO...

Hi Folks, I receive a timeout error when attempting to execute code from a command button that the user clicks, the code simply reads criteria from several list boxes that have been selected by the user and uses those elements in a select query to display the total units. If the user selects...

If an individual selects one or many items from a list box that is bound to a table with the multi-select criteria enabled, how would I remove all selections from that list box that the user selected once a check mark box has been checked? I cannot use Me.LstBox.RowSource = "" because in that...

Hey Folks, I developed a access database program a while back for a non-profit government agency; the tool works just fine and simply accepts a user entered valid date and then the user hits a command button that transfers files to certain locations depending on date entered by the user. Is...

Hey Folks, Got a question: I created an access form with a subform inside of it, the form opens automatically once the access database is opened ... everything works just fine. However, obviously the very first record in the dataset is returned and displayed on the screen once the form is...

Hey folks, I use to know how to perform such a query, but haven't in so long I am lost ... hopefully someone can help. I have a very simple base table that has a unique person identifier as well as a unique date of service. I have the table sorted by unique person identifier then by unique...