Hi all,
I'm in the process of creating a check register in access. There will be 100's of records. II have the records sorted by date.
I'd like to be able to have the form auto-scroll do...
I want to put some VBA procedures I've developed into a dll.
I've used Visual Studio 2005 to create a mini-VB addin to try to get the hang of it.
I can "connect" to the addin from VB ( by fi...
HI Im running windows XP and have Access 2000 installed with a number of complex mde and mdb files with some VBA, OCX and front end back end linkage. All work on access2000 runtime or 2000, 2...
I have a txt file of address labels. They are importing into one field of a table. Some addresses have 4 lines, some have 5 and each group is separated by 4 blank lines. The sample data loo...
I have a PropertyType table and a Loan table. The PropertyType table stores two values - ID and Description. The Loan table stores the PropertyType.ID field as one of it's columns. Is it po...
Anyone know how to programmatically scroll the web browser? ie:Move the displayed window down
Hi Expert,
I have to create a DTS package where there are four data source coming from MS Access eg: database1.mdb, database2.mdb,database3.mdb and database4.mdb.
In my DTS package I want al...
I've never used menubars. II'd like to create a menu to give users access to varions forms from a main form. I've followed the following instructions:
Select View|ToolBars|Customize...
...
Well, I'm at a complete loss about this one (and extremely frustrated at that!)
I've been using this database reliably now for about a month, and the login screen that opens an ado connection...
Hi there,
I have 2 questions.
First: What are the benefits to use external table links in Code, instead of creating a link through front- and backend
Second:
I learned that in Code, ...
Hello Experts! I'm getting an error "Could not update, currently locked" with my database; however, the error is extremely intermittent. With about 30 users, we may see the problem after 1 day...
I know the answer is out there, but need am feeling a little lazy.
Situation:
Access 2000 formatted database
Running Office XP
XP Pro OS.
Private LAN.
It seems I cannot get databases to ...
This should be easy, but for some reason I can't add a field to an Access 2000 table using DAO. The table name exists, but doesn't seem to be updated. when I debug there is only one field in...
Okay, I've been pouring over the articles from Experts Exchange in regards to automating an Email Merge from Microsoft Access. However all of the examples given show you how to send an email E...
I have a spreadsheet which I calculate from access. I need to be able to format it using the percentage sign to show up after my calcuation. Is there an easy way to do this?
Hello,
I am using Ms Access 2003 running on windows xp professional sp2 and I have a trouble with the replication between 2 replicas. When I tried to synchronize 2 replica I have a got an e...
We have an Access 2000 database that the users import .pos files as text files. We added the extension to the following registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Tex...
I have a form that contains three drop down boxs [strPlantName], [strSupplierName], and [strManager]. I want to use these as filters to open another form that is tied to a table. If a box is...
Hi
I have a form with a combo box and it's values are from the table. it listed all the months of each year(from Jan 2005 to Jun 2007). how can I hide the months that older 1 year from the ...
VBA Issue on Access 2000 database.
When running a "Picklist" report from a form, iit runs a section of vba code which up until now has worked perfectly. There are NO breakpoints set within...
Access 2003
Pdf files are in A folder called C:\Program Files\pdfPages
0001.pdf
0002.pdf
etc.......
I have an ActiveX control on a form.
I have 2 buttons on the form.
Next and...
What I am wanting to accomplish is to disable a button on my main form that opens another form based on the user. I want the control enabled for user1 and user2, but not for any others. I ca...
I'd like to create a bunch of forms that are all the same size. What's the easiest way to do this?
(vb6.0)
PS: I already have some existing forms that I'd like to resize to the same size, ...
How can I create a connection string to connect to a database on another server? I have a website sitting in a virtual directory on server "A" and I need to establish a connection to an acces...
Using CDO internet connection through an event proceedure in an Access db, I neet to copy a MS Word Document (text and images) into the body (objEmail.TextBody = "Text Body") of the email or...
