Is it possible in a ms access report, to print the report footer on the first page of the report instead of the last? I need text just on the bottom of the first page, and I don't have room t...
I'm completely new to VBS and I have an urgent need. I need to create a VBS script that will delete all the records in several tables in an Access 2007 database. Has anyone done this?
I want to simply pass ALL of the property values from a control to a function using the "control source".
Example:
Let's say I want to send a control's tag to a function
The name of the ...
Hi!
I need urgent help!
I have a access database and it is placed an a share folder. I put permision to all users on the folder and also I put permision an the database. On the share folder ...
I've constructed a junction table that creates a many to many relationship between Product Manuals and Product Models. How do I query the data? For example, if I want to find all Models that...
Hello Experts,
I was helped to write the following query for a MS Access database that runs efficiency reports for my company. This query gives me a weekly efficiency average. The only is...
I am using SQL Server 2008 and am in search of the AdventureWorks2008 database. I have gone to the Codeplex web site (http://msftrsprodsamples.codeplex.com/Release/ProjectReleases.aspx?Releas...
Hello Experts,
I have build a change log table in my access database. Whenever anyone is changing any value using the form I am using the beforeupdate event to capture the changes. I am using...
In short...
Can I wrap an Access 2007 ADO transaction statement around a SQL Server stored procedure (that may contain a transaction itself) and have the various transactions successfully ...
I have this code to load up images from my local server, Now I want to change it to take the images from a website,
So i changed the 'ImagesDir' varible value to the website address
The...
I have a list box that show specific data based on the ID of the employee. I need it to show the Site numbers that the employee works at. It needs to change with the main record changing. Mea...
Hi
I have the below code which Ive used in my DB to send e-mails via an smtp server, but I cant figure out how to attach a report to it or even use the report as the HTML body text.
Ca...
I have an Access 2000 database, residing on a network. The database consists of a front end and a separate back end.
I store pdf files on the same server that the back end resides
Using the...
I like to have a QUERY that selects the LAST 3 scores by date and places them into separate columns:
EXAMPLE:
id Score score_date
111111111 100 3/11/2009
222222222 100 2/1/2009
222222222...
I am using the below code to set values n excel via an access module code
i am using the int numbers to access the cells which works fine
what i need to do is to set uo the data line so that...
I have ieframe.dll and shdocvw.dll in my system32 directory. However, I cannot find "Microsoft Internet Controls" in the list of reference libraries in the "Tools>References" list from the VBA...
I have a query that does not find a mtaching record in joined table. When this happens the field has #error in it. How do I replace the #error with 0?
Hi.
Can I force Access to use dot for decimal numbers?
I want to currency
6000,20
to be shown as always
6000.20
If regional settings is changed(setting "," instead of "."), Access da...
Hi Experts,
I need to add an IF statement to the SQL below, that basically checks if [Forms]![FINAL_Form]![MthCombo] IsNull.
Current SQL:
FROM Data_Tbl
WHERE (((Data_Tbl.Mth)=[Forms]...
Is it possible to detect if MS Word is installed on a PC on the fly?
Hello Experts,
I have a simple table with 3 fields:
ID
Name
Time
The table contains 7 records with 4 uniques names (Alpha, Bravo, Charlie, Delta). For each of those 7 records, I hav...
Hi x-perts,
when I import an Excel sheet directly via Access, there is an option to add a primary key. How can i do the same with DoCmd calling from VB.NET?
This is my current command li...
A junior report question. I have a report that has 10 fields and seems one line can't hold all the records (in print view, the later three fields will be in next page). I've revised font size,...
In my Access app I have code on a form that allows for selecting the printer for the report chosen. I would also like to allow the user to choose the print quality = draft or normal from this ...
I have a query that pulls the client, company, date, and balance. This needs to be populated into an excel sheet that is formatted similar to a pivot table with client code and client name on...
