Folks,
I've not done a form/sub-form and after feeble attempts I need help. My table tblDailyProduction has three fields I need to key off of: ProductionDate, LineCode, Shift.
Let's start wi...
I have a connection to an SQL database and want to grab the value of a field called state.
The State field appears in a subform that is populated (filtered) when a combo box is changed.
Th...
I have a form bound to a query. On the form are two text field that auto-populate on an afterupdate event of a combo box. The first field is "txtCustomer_1" from the query field named "Custo...
Is it possible either in Excel or in Access to take data that is over 240 characters, cut it off and move the remaining character to another field and then again if it is over 240 characters t...
I have a function that I pass a record id to, this function copies the field values into a new record and does an insert. I need to capture the new record's ID. Can you help?
hi,
I have the following code under Report_Open of my report:
If IsNull([Forms]![frmNMain]![cboSortBy]) Then
[Forms]![frmNMain]![cboSortBy] = "RNo"
Else
Me.OrderB...
Hello,
I have 2 subforms in which they are table driven. reason why is because these 2 subforms control a check box, [Complete] ,that modifies the table 0 or -1. i have create 2 command bu...
I have an Access database that when loaded needs to ensure that the application and then the form are maximised. I thought a good idea might be to put the following code into the Main Menus l...
need some help with VBA code to connect database to Exchange server ... I am running the DB from an admin account ... just need to know how to connect to the Outlook mail exchange then in code...
I would like to open one form from another (edit form from a list form); however, Access does not seem to like it when I am pulling data from more than one table...
I am using a macro to op...
Are there any known issues that come up with a database that uses an Active X Calendar.
I created a database back in Access 97 useing an Active X Calendar. The database has been converted t...
I am quite good at cleaning down variables such as recordsets etc. But I wanted to know if there was a function that would cleanly wipe any variables - just to double check things (for exampl...
Hello. I have the below code that works perfectly in excel. I have never tried to do this in access before and simply don't know the syntax. I'm looking for assistance on making the following ...
I need to create a total cell at the end of the column in an excel spreadsheet I'm creating using excel automation to output data from a query. The export works perfectly but I have no clue o...
It has been a very long time since I created an Access Database from scratch and I need to do that now. Who can help me? I need tables, forms, and reports. There is little logic built in. ...
I have extracted data in a query from our huge database with accounting amounts located in the trans_amounts field. Some amounts are negative and some are positive. There is a field called dr_...
Another question which probably has a simple answer but I am new so here it goes.
I want to send an automatic email from a form in Acces, altering people to that a new order has been entered...
Hi,
I need help in putting together a basic stock management system (perhaps that's a little contradictory), which will allow me to manage stock replenishment and show sell thru rates etc. ...
I have a linked SQL table (dbo.Solicit_POD_Email) in an access database, and i am unable to run a delete on it,
I'm just running a delete all sql,
DELETE
FROM dbo_Solicit_Pod_Emails;
A...
my access 97 db i need to run queries aganst tables in sql 2005; odbc is to slow, people say that ole is faster but i cant make the connection string connect right. Any and all help will be a...
I have a Table in Access, each time after a report is generated in MS Word (by using Access Coding), this Table will be updated with the information of "generated by whom".
How to write the ...
My question is very similar to this previously posted question. The difference is that the solution posted assumes that meter readings are taking monthly. In my situation the meters are read...
I have an update procedure in my Access 2000 application. It is in the attached snippet. I use the same parameters to run the procedure from an unbound form and a form that in bound to the t...
