I need to transfer data from one table to the other. In tbl_SoftwareTransfer I want to transfer the data from the following fields, SoftwareName, SoftwareCompany, SoftwareVersion, SoftwareKe...
Hello,
I am looking for the correct statement in Access - "does not start with".
Currently I am using Crystal Reports and it shoes the folloing formula
"not ({OL.OL_EXP_ACCT} startswith ...
I have a form with a linked (child-master) subform. I only have a problem when I am entering more that one set of records at a time. Between "ADD"s - the subform does not clear - it seems to b...
I need help associated text detail with a particular task as entered in frmAddTasks and shown
Later I will want to associate detail with a day as opposed to a task but just task for now and O...
in another post i was advised not to use linked tables in my sql database.
at the moment i'm developing our database in access with the hope of transferring to our sql server.
are linked...
I am trying to include an <All> field as one of he combo box choices. I have done this before but when I tried to duplicate the code, I got an error about the number of rows not conforming.
...
I have a very simple database setup that seems to be getting more complicated as users continue to ask for more things. It is in Access 2000 and is 1 table and 1 Form. If a user makes any chan...
hi all,
I have a set of letter used for accounting purposes and need to increment them.
The first letter in my tblAccountLetters will be AAAA
the next one should be AAAB....until afer AAA...
Hi, how can I sum on a form all the [Amounts] where COID = me.COID? I have many amounts per company. All the amounts are in tblFacilityDetails. I have made an unbound field on the form but n...
I have a memo field. I am trying to determine if there is a word/phrase in the field.
How can this be compared via VBA so I can post a message if a word/phrase is not found?
Number field in a table stores the duration of an event in seconds, which has been calculated from 2 fields with time information in them.
I need to display this data on a form in hours, mi...
I have a table that has a DateAdmitted, DateCompleted, DateLeft. I have a query that asks for anything between START and END of Either the Date Completed or the DateLeft Field.
So there is a ...
I can't remebmer how but I was able to upen an Access database that had linked files without the links conecting. There was a keyboard sequence like holding the shift key when opening the dat...
I have a small Access 2003 application that will run in 3 different offices. I'd like to make a VBA call on startup to detect what office the app is running in to set a couple location-specifi...
I'm trying to set a filter for a subform that meets either one condition or another.
What I have is
Forms![lstCashFlowToInvoices]![sbfrmCashflowToInvoice].Form.Filter = "[TotalIncludingTax...
I am going to be starting a project requiring the extraction of documents residing in a Novell environment to an Access 2003 database residing in a Windows environment. What issues will I nee...
I have a SQL statement that I added more code to prevent duplicates. It worked OK until I did this.
The error I am getting is "External Name Not Defined" (I will put an *** over the name refe...
I've asked this previously, but phrased it badly, so here goes again.
Where do I declare a Global variable so it is available throughout the whole database, bit just in the form it is decla...
I want to count the number of entries in table "registrants" that do not have delete turned on.
A friend helped me set up the queries CountRegistered and CountRegistered_Crosstab in a diffe...
I have a subroutine (see below) wherein I want to run 4 reports. These 4 reports use the same report object; each time I execute the 'DoCmd.OpenReport' I pass in different OpenArgs. What I wou...
I have a Access 2000 DB with tables linked to a AS 400 application database. When I run a query on the Access DB it prompts for a password. I do not want this prompt. Is there any way I can st...
Hi there. I have a subform which forms part of a main form in a database, the main form being client information (DOB, Address, etc) and the subform being contact information which includes d...
I am a network engineer working with a programmer and web developer on this, so I am not the Access guru here. The mdb has a macro called autoexec. The mdb file is not getting recreated when...
I have this subform (datasheet mode) that is bound to the form. How can I limit the number of records in the subform to 10. Also, I have a numeric field in there where a user inputs an orderin...
Is there a way to convert DIB images to JPG images from Access VBA? Either some kind of function or even a free command line program would work too.
