Hi,
Please open frmPatients. You will see Visit encounter subform if you double click on any encounter diagnosis. A form (frmPatientVisit) will open. I am trying to let the user change t...
This is post is in response to an earlier post: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23569905.html
I'm using the following code to delete t...
Hello, is it possible to use the Access 2007 developer tool(s) to install an updated form (and of course, delete the original) into a Access 2007 application that has been deployed? The packag...
Along with deleting the target files i would also like to delete the file path itself stored in the table (this will also be dependent of the datediff value being >30 days. I would like to pro...
I have a connection and SQL statement from mdb to AS400 to extract records and save in mdb table. I'm getting the correct number of records and NUMBER fields are coming in OK. But text field...
I am setting up an Access application to synchronize a master database in the home office with remote office locations. I will have the remote locations export a file (xml?) and then email it ...
Hi everyone-
I'm not sure if anyone can help, but I am creating export specs from an access table (200 fields). The export is to be fixed length text. Everytime I type in my field names- st...
Ok, so this code is supposed to take data entered into a form and store it in two different tables: AS9100RequirementFunction and AS9100RequirementDocument
I have made msgboxes (no longer the...
I would like to be able to create charts on the fly in Excel. The data is in an Access database.
I would like to be able to select a variable from the database, provide binning values, retu...
Hello,
I have a combo box that when I select a value from the drop down, the value is used to change the criteria in a stored query. But I also want this to work as I am typing text into th...
I am using the findnext method and for each record found, I take an action.
It's seem, that I have an infinitive loop.
Do I have to use the Movenext instruction with a findnext ?
Privat...
I have a form that has combobox's...
I have the first one populated with our "TOP LEVEL" organizational names. When a user selects the organzation, I want to have the second combo box get...
I have a simple function to give a group category to a person's age.
In running my code the variable age will calculate the correct age. Let's use 18.
In my Case structure the 2nd Case ...
I have a table with a bunch of names in the following format: (Last, First) (i.e. Sampson, Brock) Sometimes there are extra spaces after the comma.
What query or code could I use that would...
I have a table with a single field titled: "SSNumbers". This field contains a list of numbers. What VB code would I use that would find the largest number in the table and display a message bo...
I have written code to create queries on the fly, however, I am looking for code that will delete any and all queries from the database on close of a form or on open of the main menu. I am us...
I use a routine to call a chart in a form. When it is first called the graph layout is messy, with the legend overlapping the plot area.
However when I step into the code it draws neatly. I...
I am using Access 2003. I have a form with 2 datepickers on it that drives a query that calculates totalsell, totalcost and totalprofit. When I add date to the query I get weird results, howe...
I have a form where navigation buttons are set to "Yes". The form is not continuous.
How do I make it so that when a user presses on any of the navigation buttons, code will run.
i.e. Wh...
How do I change the default value of a field on a table using VB?
I have a table titled: "Table1" with a field titled "Type". I have a form with recordsource = "Table1" and a textbox with c...
I noticed recently that a database continues to grow (almost doubled in size) over a short period of time. The growth is not due to an increade in data in the database. Would the use of VBA ...
Is it possible to update and/or add VBA code, Macros, Forms and Reports in an Access 2007 DB that is in runtime mode (.accde)? We want to be able to make changes to the screens and reports bu...
Can I use an array or something else to choose the last 3 customer records? I'm trying to show an order history and we can to do the last 3 records by their transaction date. How can I do thi...
Hi
I have an Access report. I need to open a specific Excel file when the user closes the report. I've used Event Procedure on Close and have tried various bits of code from the answers I...
