Can anyone tell me how to create a time field that does Hours, Minutes, and Seconds?
I have tried Short Time, but I lose the seconds. I tried Long Time, but it adds the AM/PM - and it also c...
I need to execute a stored procedure using VBA in my Access front end. The stored procedure:
CREATE PROCEDURE danhomp.spCreateRandomingView
@PubID varchar(...
i have a split db in Access 2003 that recently had the blank drop down box problem when it was placed on the client server. It turned out that sp3 had been installed on their system and they t...
It's been a while since I've worked with a database, so hopefully this is an easy one.
I have a table on our SQL server called "dbo_SalesOrd" which contains three columns "SalesOrdID", "Dat...
Hi experts-
I'm building a small access program that cycles through an email list table and sends emails/attachments using the CDO Message object. A small sample of the code I wrote is below:...
MY code from help on ee is
Undefined funtion "format" in expression. Maybe this is the cause of the form to report process failing
PARAMETERS [Enter Start Date] DateTime, [Enter End Date]...
Is there an easy way to iterate through access tables and get a count for every one on my system.
I would like to do it with queries as well
Hi,
I have a problem with the values returned by SQL Server when I perform a CAST or a CONVERT. I have an Access db that I have migrated over to SQL Server (both DBs are on the same server...
i have a split database.
i have changed some field names in the backend tables and created some new tables.
linkmanger does not update the new table or the name chages in the fe tablenames.
...
I want to either export or grab one line from a query to keep a running log of activity. I have a seperate program (we'll call it "other') that spits out the results of a search into a .txt f...
Here's another one basically out of the book. I really think I have a dud book (Access 2007 Bible). I'm getting the error message "No value given for one or more required parameters." What ...
Hi guys,
I would like to know if it is possible to create a parent form in access 2003? What i want to acheive here is to keep this parent form on the background always open and maximised, ...
I'm importing an excel spreadsheet into access as a table. The spreadsheet contains a column with text entries like "1, 2, 3, 1R2, 3" (entries separated by commas). After importing there are n...
I am previewing a query so my user can print it, very simple. However, I wish to add a disclaimer note at the bottom. Because I am allowing my user to define the fields in the query, it is n...
I have an Access file that has several links to Excel worksheets. Several of the worksheets have formulas that mix numeric and text values, such as the following: '=IF(A5,5,"Alpha")'. Excel ...
I have three tables: Employee, Transaction, Locked_Obejct. Employee is related to Transaction by employee# and Locked_Object is related to Transaction by object#.
How do I create an entry for...
In a previous question, I requested the ability to concatenate fields in a group by query. I found out that I need to be able to concatenate only those entries in the field that are not alrea...
I am uploading an Excel Spreadsheet. It has a range defined as to what to pick up. When I upload it into Access using TransferSpreadsheet, it gives me a Numeric Field Overflow error. If I c...
The macro should be the following code
I don't know how to create it with access 2003
Dim LPath As String
LPath = "C:\temp\RefDaf.mdb"
If FileOrDirExists(LPath) Then
Kill L...
I have a form with 10 text boxes. On the form I have a combo box and on change I have the code below to lookup data in the weekresults table and put it in the textboxes. It works but my prob...
Hi ,
as question, how to get the path of "My documents" even the folder is redirected?
I saw many people use "%userprofile%\my documents" to get it , but it does not work if the folder i...
I have setup an MDW file and user level security on an MS Access DB. I am unable to delete the default Admin account that is created. When I attempt to do so, I get an error message saying ...
I have two summation queries and I want to add their value together. I also need them to be able to handle 0's if they ever come up.
Query1.Field1+query2.Field2
Filed 1 and field 2 have...
I am using Access 2007. I would like to know how to have a definition/explanation display when a user does a 'mouse over' a label on an Access form. I attempted to do this using the Proper...
Hello experts :) I have created a small helpdesk application using MS Access. It is used to log calls and assign the call to members of the helpdesk staff. When a new call is logged, I would l...
