I impored an HTML table & it has where I'd like a new line. How do I make that happen? It's easy in Word, but there are no find/replace features Access for formatting. Guess I have to...
Here is my access report. I've seen multiple posts on this issue and nothing seems to work. I have grants that affect multiple cities, counties, and districts. But I want to sum the amt awa...
Hi Experts
Can you create a report and then add X number of subreports?
I'm using Access 2003. I want to append only the current record to another table and then delete the current record. This will be a way for me to archive completed records. I would prefer t...
THI
I am office worker
THE JOB REQUIRES TO GET DATA from OUTLook that is in emails in outlook folders IN feilds :To, From ,DATE, ATTACHs CC Body
direcley into and outlook data bas...
Hi. I have a form called frmRGInfo bound to a table called RGInfo and another form called frmRGCredit bound to another table called RGCredit. My users have to fill in a field called InvDate ...
does if isnull only run if a variable is null?
Should I be using the second set of code instead?
Can someone please explain what the "Allow Value List Edits" option is for in a combobox. What does it do when set to yes or no? Thanks.
Hello to all of you. I have posted the code I have been using for a while to export no it is telling me that error I wrote in the subject. Any Idea Why I would get this. There is over 65,000 r...
HI
I am using the following code to create a recordset from a SQL statement. How do I get sum and average values of some of the fields of this recordset.? Whats the best way? Should I use an ...
Below is code for using a date varible in a SQL where clause. The date is coming from form frm_timeadj field text0. If I hardcode the date it works, with code below, I get no records error.
...
I have 4 fields in which I enter numbers. As I am entering them I would like them being totalled in my 5th field. How do I do this?
Experts - I am getting a Run-time error '2424' on the Public Function below. I have the declaration...not sure why Access can't find it...
Thanks.
I'm using the VBA code below, to attempt to output a form to a .snp (snapshot) file. I receive an error, stating that the current format that I'm attempting to output the object to is not ava...
I have an MS Access form frmA tied to a table tblA. All of the controls except 2 new ones that I recently added, are tied to some field from tblA (i.e. their Data Source) is some field in tblA...
My Access application currently uses System DSN links to a SQL Server DB. I have a routine that allows the linked tables to be switched back and forth between the live data and a test databas...
Hi! I need sequential numbering in a table or query. Can not use autonumber because of losing a number when deleting a record. Also, initial data has been imported and the number is tied to...
Hello ~
Could someone suggest a way to query a field for all field values containing non-alpha-numeric characters. I've written the following to find all instances of "#", but I also need ...
I have an Employee Table (tbl_Employee) in my DB that I want to allow a "Power User" of this DB to maintain by importing an Excel spreadsheet from an old HR system to compare records. I have ...
I have a database where i store images (OLE OBJECT) and the field inside the table has the value "Long Binary Data".
I am trying to copy everything to another database and i would like to cop...
I have a report based on an actual Query (not VBA query) and I want that report to be dynamic. I believe that best solution is to edit the actual query it is based on according to the form, s...
I have 2 tables one is tbl_Charges & the other tbl_Liability.
The tbl_Charges has a primary key for case# column. The table also has a position column.
The tbl_Liability looks like this.
B...
I need to create a report to print a manufacturing work order production steps traveler (for those familiar with manufacturing this is basically the production routing/bill of materials travel...
I have developed a basic Time and Attendance system which uses a magnetic card reader for users to input to the system. The following code captures the time and date users clock in and then r...
I want to make a autonumbered field by code.
I don't want to make it in a form but in deisgn mode in the table
Is it possible. And how can I do so?
