Hi Experts,
Thanks for your time and knowledge
On my form I have a unbound combo box that acts as a record selector. This main form has three subforms on tabs. Yesterday it was working,...
I have a table defined with 2 fields. PayPeriod and Range. example PayPeriod 20 Range 9/22/08 - 10/4/08. I need to compare the current day against the range to query the current payperiod o...
Hi,
From, my frontend database, I would like, by vba, copy a table from an other access database in my backend database.
I use :
DoCmd.TransferDatabase acImport, "Microsoft Access", _...
I have multiple forms in a sequence based on a single record. The final form has a command button that exits the form and prints the record details onto a Report. It obviously saves the data...
I am continuing to write sql for my database and have encountered another question.
This is what I have:
FRT Due: IIf([DATE_ESCALATED]<=[DESIRED_DD],[DESIRED_DD]),IIF( [DATE_ESCALATED] >...
I have a form that has two subforms (Continuous) on it. When I trigger the Main form to open the sequence of the loading of the subforms appear to be changing. Sometimes the sequence goes Su...
Can someone give a simple query that capitalizes ALL contents of a Table called "Customers" in an Aceess DB?
Thanks
Hi being new to Access i want users to be able to complete an excel (2003) form and hit a button that will load the data into an Access Database, im confident i can write the VBA but cant seem...
I have several forms which are based on the same query. I want to jump from one form to another and find the record with the same identification. I have had no problems until now. Now I receiv...
I am using a VBA code in MS-Access to change the printer dynamicaly.
I have the following code:
MyPrinter = "HP Laser Jet"
APPLICATION.Printer=APPLICATION.Printers (MyPrinter)
But MS-...
A2003XP. I've developed (with EE's assistance) a methodology for generating Word documents from an Access form. All of the templates for the users are located in a single folder: C:\Wordtmp...
When a form is a subform of another, the Parent property returns the form that the subform is contained on. What is the best way to determine if a form has a Parent form in code?
For exampl...
I have a query that brings back 300K+ rows. I need to only see those rows that contain alpanumeric data in the address field. I have tried to use Like "[0-9a-zA-Z ]*" in the where clause but...
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...
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 ...
MS Access 2002 Form 8 text Boxes holding Calculated Value - Wan to change Backcolor per text box based on the Value. Want to write VBA code to handle changing color of backcolor based on valu...
Hopefully a quicky - I use Redemption quite extensively in my application but I have never been able to figure out the safeinspector, can anyone suggest how to rewrite the attached code using ...
Following on from this question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23695626.html
I find that the line:
strSender = msg.SenderName
...
i use this to find the next number
Dim lngNextnvNum As Long
lngNextnvNum = Nz(DMax("[field]", "[table]") + 1)
however i would like to add a criteria/filter to it. like this:
lngNextn...
Hi,
I have a huge text file which I have split into multiple variables, and now I need to be able to put them into a table. Some of the lines cause changes in the values of some variables, a...
Long story short, I'm trying to run an update query that uses multiple tables (actually runs from another query for that matter) and I keep receiving the error message "Operation Must Be an Up...
During converting from Access 97 to 2000 I have compilation and run-time error on this procedure. Database was converting through importing all tables, queries, macros, and modules. Error wa...
Hello,
I have a listbox that populates via hard coded query in the after update event of a text box. What I would like to do is take the results from this listbox and insert them into a tex...
hOW DO I TELL A FIELD IN THE QUERY TO EITHER
SELECT FIELDS THAT CONTAIN A VALUE "CALL ME"
OR BEGINS WITH A VALUE "CALL ME"
THERE WILL ME MULTIPLE VALUES IN THE FIELD TO SELECT SUCH AS
"CA...
I'm totaling up some numbers and then divding by 2.
If the result is a fraction (i.e. 50.5) I need to round up and display 51.
If not a fraction, then just display the 50.
Is there any kind...
