I have a Microsoft Access query that pulls client data. It has three columns
- Client
- Sent
- Received
A typical query output may look like this:
Client Sent Receiv...
Hi,
What i make is an access macro reads from excel and insert into a table'student' all duplicate values removed wrt student id.I attached code below.
Same way i need a form when we cl...
Hello,
Please follow this link:
http://www.mvps.org/access/datetime/date0012.htm
I have already implemented all of the functions into my database. Everything works great. Now I'm tr...
Hello, Im trying to enter the current date an time into the suitable text boxs when "Closed" is selected from my drop down list. My db is sql but I have made the front end in Access. Im presum...
The stored procedure returns rows in SQL Server Management Studio.
The recordset is defined and behaves as if it is not open.
Set cmdFrrats = New ADODB.Command
With ...
I need to delete the record itself not just the data from the record which is what is occuring with the code that I am using. This code is attached to a command button on a form.
I have the following code which works:
Dim obj As Object
Set obj = ComDialog.Object
obj.Filter = "Access database (*.mdb)|*.mdb"
obj.ShowOpen
How do I set the default...
The code below works fine when it is placed in the database it is making the relationship into and i set the dao.database to currentdb but when i try to have it create a relationship into anot...
I have several applications built in Access that interact with Excel, Word and PowerPoint. I am upgrading the apps to Access 2007, but will have to continue to support users who are still on ...
I'm puzzled.
I have a subform that stores course information for a student.
In the BeforeUpdate event, I have simple data validation rules to check that all required fields have been e...
hi
I have a function reference library called MyFuncLib.MDE. In other user MDBs or MDEs I set a reference to MyFuncLib.MDE. Then in the user MDB/MDE I can refer to my function library. It w...
I wonder if anyone can advise on a code snipet to count the number of lines contained within a Memo field. The mmo field in question will never contain more that 6 lines, but I need to output ...
I have a basic form that uploads data from a spreadsheet, populates the fields and assigns a number for the project.
There are 3 tables involved: tblPlan, tblStrPlanBldgs, and TempSPBuildin...
The following code is several forms - it opens a dialog, where you can select a file and insert the hyperlink to that file into a field on the form. The example below is frmContact and the fi...
Trying to open a database in Access. the error message is "there isn't enough memory to perform this operation please close unneeded programs and try again"
i am no expert with access. thi...
Hi, I have an Access 2003 ADP (Project) application that I would like to be able to use to search a file store containing 1,000s of Word documents.
I have found the details of Windows Searc...
Hello,
I have a button [cmd_newPHI] on a form. When a user pushes this button I would like the message "Do you want to add a new patient?" With the message box options being yes or no. If t...
Hi,
I have this code (see example). I was hoping that it would upload the files in C:\Documents and Settings\Desktop\TestFolder\email
To
/var/www.html/email
However, nothing happ...
What could cause vba code execution to simply stop without an error?
I have one user running Access 2000 that attempts to export a report in snapshot format using a procedure I've attached to...
I am using Microsoft Access 2003 and am trying to create a query. I have a main table and sub table with a one to many relationship. I want to create a query that includes specific values from...
I have a form (frmDataInput, in the very early stages of development) which will be used to enter or edit data for a particular "case" in my database. When you load frmDataInput, a dialogue f...
A2003XP. I need to generate a date that is 4 business days (not including weekend days or holidays) earlier than another date (call it ActivityDt). I can find routines that calculate the bus...
Error 3061 - Too few parameters. Expected 4
I had this error when I update the information in an Access form:
Set dbs = CurrentDb
Set rsQuery = dbs.OpenRecordset("qry_Calen_type", dbOpe...
Hi,
Could not believe I couldn't find this on the web so sorry to ask. I just need to return the system date (so date at the time of running the query) as a value in a field. Can not for th...
I had a developer create a student scheduling database for our organization. We are having a problem where if we have two students with the same last name, for Example, Abraham and John Smith...
