Hello,
I was hoping someone can assist me with my code. I have built a form for our users where they can copy and paste data in certain fields (fields are in datasheet layout). The code check...
I need to round the amounts listed in the query TasksLogPeriod, field durationTime 'up' to the nearest positive integer as represented by hundredths of a minute.
The intent is that this wil...
i want to get a field value of a subform.
I get the "No current record", when I try to access it.
via
Form_subform.Recordset("FIELD")
in the first form code
the record is displayin...
On all of my forms I need to add a "Delete record" button. Does anyone have some sample code for this type of command button?
I was handed a Access 2003 DB that was about 80% complete. I have been finishing it up the last month and learning the database and how the app functions.
It is a replicated database.
...
I'm creating a Search form which has the various fields from the database/tables in it. I'm using the same code/example provided in help.
However, the code only explains how to cycle throu...
Dear all,
I would like to know how to relate 2 tables in access. I am relatively new with access and I have tried everything and searched for related articles but could not get it to work. I ...
Hnasr created this database for tracking tasks. He has spent an obscene amount of time on it and has done a great job! His form is SLICK and is the real fruit of this project.
What I wo...
Hi,
I have this line of code:
DestinationPathAndName = systemfolderpath & "\" & "documents"
Which sets a path for a document which is being added into the database. What i'm trying t...
I have a combo that I set the rowsource and I want to set the value to display first item in the drop down list.. I am drawing a blank? This is set on the fly.
Thanks,
k
I am trying to set a passthrough query to run via VBA the code grabs the product ID and puts that in the SQL for the passthrough it them is suppose to run a append query that runs off of the p...
Hello,
I currently have the following code which I have attached to import the spreadsheet into the table 'Age_Debt_Table' But when I open the excel sheet the first line is a generated head...
I have an app that I am converting from Access 2003 to Access 2007. It has a main form with a few sub forms. On one particular sub form, when I click one particular button, I get the error "...
I am using VBA in MS Access to create email messages. I would like to create messages with return receipt, but the command "With oMsg .receipt=True" does not work, as well as the command ".F...
Hi Experts,
I have two tables.
1.Patients (Patnum,Patname,address,city,postcode)
2.Postcodes (suburb,postcode)
However due to incorrect data entry operators have entered city and postcod...
Hello, I need help with two things.
1) A custom function that returns the number of calendar days between two dates/times
2) Help with a custom function that I already have (it is below). ...
I have an Excel spreadsheet that contains product numbers. I want to be able to highlight a range of product number cells in Excel, and In Access, run a parameter query with the values on the ...
I'm having a big problem using a listbox in VBA, creating a project to be used in Outlook.
I've created a listbox with multiselection and I can't get the selected values.
The listbox is ma...
Access 2003 -
I have a form that's giving me trouble. When I choose a selection from my combo box, I have three subform record sources that change based on an afterupdate event of this cbo. ...
I have a table with a bunch of names in the following format: (Last, First) (i.e. Sampson, Brock) Sometimes there are extra spaces after the comma.
What query or code could I use that would...
I am trying to run a query that will look for things that are current day -2, back 2 days. The query is pulling from a link excel sheet. An example of a date inthe query is 8/18/2008 1:21:24 ...
I have a databse form with a listbox that needs to display an event diary. The diary displays a date, type, and comment. I have two tables, one for the Main Form (tenant table) and one that co...
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...
I need to determine if a field starts with an Alpha character and if the length of the field is > 3.
I have a field that could contain the following data possiblities:
C1
CH!
A09
A9
...
Hi,
I have an access form which has import records from the excel and do some works like duplicates check after that insert the appropriate records into the table.The manipulations are done...
