What I want is to print a series of sheets, each one containing a full size vehicle image and a footer with some data (basically plate and date).
To do so, I have an Access 2k table with th...
i want my code to get me some details.....
Me.SI_4 = Nz(DLookup(" [sumofgross] ", "CA_SI_BankCredits", "[bankac]='" & Me.BANKAC & "'"), 0)
this works if i have the "USD" in ME.BANKAC
...
I have 10 fields with the same name but different number at the end as a result of a recordset query, CHILDPID1, CHILDPID2.... Instead of writing a code to check each field, I like to look thr...
Instead of using the following VBA statement...
DoCmd.OpenForm FormName:="frmItemLocations", wherecondition:="[Code] = '" & sCode & "'"
How may I change it to where instead of narrowing ...
Hi Experts,
I am conveting a access 2003 database to access 2007 and getting a lot of compile errors. I have fixed a few of the missing libraries and most seem to be ok. On the below sub I...
hi:
please
i need a clear example of the deffrence between passing the parameters with
ByVal or ByRef
Hello,
I've created a data entry form in MS Access with several controls and placed a bunch of Yes/No fields in the footer of the form. I want only certain Yes/No fields to appear based on ...
I am using a SendObject to send emails to Outlook and I would like to be able to create the queries on the fly and also name the attached file on the fly. I am looking for the best approach.
...
I have a database of calendar type items. I generate a weekly report that pulls all records with a Start Date of the current date through the next three months using the following function: Be...
I have a database, created in ms sql server management studio express, that is maintained in access 2003. I have the following columns: LoanNumber, LoanAmount, LoanTerm, LoanDate, InterestRat...
I have a very simple form that I enter temperatures for a range of dates. The fields are Date, High, and Low. The record source is a table called tbl_HighLow. For this particular tables fun...
I am adding a set of data from an access 2000 form to an access 2000 table. This all works well until I close and reopen the database. before the database is closed all records are concurrent....
I have a field in a form that has data that almost matches data in a table except for a few characters at the end of the string on the form data.
Is there a way I can replace the data on th...
I have an Access 2003 db form. In the form i have the follwoing to send an email to a receipt after a from is filled out.
Private Sub SendMail_Click()
Dim strTo As String
strTo ...
Hello,
I have 2 command buttons, Red & Green. The Red one turns a rectangle's backcolor property to red, and the green button turns the same rectangle's backcolor property to green. That pa...
Can someone help me with a way to create a button on an Access form that checks the display size of an image on the form?
I need VBA code that, when activated, will check for the existence of a file and, if found, will create a new record that stores the modified date-time attribute value. The code would need...
I have created a database for tracking medical visits to a first aid center on a project site. The database has a few tables that are linked to make the database more user friendly because it...
I would like to update some of my forms to have a more professional look. Currently, I have command buttons on the form to perform tasks like saving the record, printing the record and openin...
I have a table that contains a single record that gets deleted and appended daily. The table contains three number fields. When the append query runs, it takes the number (example: 805.5) a...
Experts,
I need a do a thing in MS Access and I think it is a standard problem.
We have a table. the primary keys for this table is salemanID, dateID. other entries are quantities sales ...
In Access 2003 I have field A which is an email address. Field B is a date field. I'm looking for a macro that will send an email to the address in Field A when a date is entered in Field B....
I have an Access 2003 Front End that connects to a SQL Server 2005 Back End. I need to select documents from a local PC and store them in a table in SQL Server. At a later time, I will retri...
I have a query that counts the number of days taken to process a particular job in our facility and reports if a particular department has exceeded allotted time. I need this query to disregar...
Hey everyone,
In excel there is a very nice RoundUp and RoundDown function. How do i get to use that in Microsoft Access 2003 on a form - need to calculate something based on a users input ...
