Hi Experts,
I recently modified a form such that its record source used to reference only one table, now it references multiple tables. As soon as I did, I could no longer add or modify data ...
I am trying to run a macro from a task or command line. Here is what i am running
c:\Program Files\Microsoft Office\Office12\MSACCESS.EXE "c:\users\xxxx xxx\facts.accdb" /x test
When it l...
Hello experts,
Could you please help me with the following?
I want to add an item on a form that is not linked the form.
The item is the total (count) number of customer records in a ...
I have a form that is launched from another form. The first thing it does when it comes up is bring up a file browser so that the user can select an Excel workbook. The user is then supposed...
I have a simple Access 2007 ADP connected to SQL 2005 server. I created a main form with a single subform ( an order with order details). Each has their own datasource (tblOrder and tblOrder...
I have an Access form and the datasource is set to a linked SQL server table. Most of the time, the data is correctly sorted (form is for work orders, work order id is a primary key, int 4, i...
HOW DO I INSERT AN IMAGE IN FORM ON MICROSOFT ACCESS
I just finished my project in ms access, now i need to set up users and password, how can i set up which objects can users use, acording to a permission level, and how can i hide all the objec...
Hello. I want to create a form in MS Access that does not require the user to have access installed in order for them to enter data into the database. I heard this is called a runtime form b...
I have a Pivot Table where I need to WRAP the text for one of the Column Headings. The full text needs to display and the length will change per Pivot. Anyone any idea please how to do this....
I have a split form (form at the top and datasheet subform below). I have a checkbox to mark which records to print. After printing I run an update query to clear the checkboxes. I can use a b...
i need a button on powerpoint slide to close powerpoint application and open an access form when the slide show is running
tried application.quit but doesnt work
Hi
I have created a form which links to a table and shows the records via a combo box. I did this by creating the form in design view and using the wizard. I particulary want the user to ...
HI Experts !
I don't know why, but I am trying to use a very simple method here called "select case" and for a reason I ignore, it simply doesnt want to return any value.
I am changing the...
.Execute() always return 0 even though the file is in the searching folder. I have MS office 2003. Can someone help me?
sDir = Application.CurrentProject.Path
sTable1 = "tbl_Projects"
...
I have a DB which is 440,108 KB
I splitted on shared folder, so the files are:
CSCC-AMT-2114008-3.mdb ---- 106,236 KB
CSCC-AMT-2114008-3_be.mdb --- 105,656 KB
I only using one table wit...
I'm currently working on a small custom database for some specialized auctions. The auctioneer may sell one, or multiple items at a single price. In fact, during the middle of bidding, he ma...
Experts:
I have a table that contains data for schools. THe table structure is as follows:
buildingid
gradeid
teacher_count
student_enroll
year
My question concerns the form us...
Hi,
Access is not my strong point. Especially as I haven't used it since college. I must say that Access was much easier to use prior to 2007. Finding something was ten times simpler.
...
I am creating a new Sales record from a form
I want to Open the Form input all the contact info and Have Submit button. then a blank reord appears.
I dont want the ability to scroll thru...
Hello,
I am having a touch of bother deleting a record from a form command
The code I want to run will ask a question before the code is fully run. Once the user presses OK, the script th...
hi there experts,
this is the second part of a two part question, the first part being here: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22567060.html .
so i have s...
I work with an application that provides user data over the web. The data comes up in a small popup box which when copied into excel looks as follows:
Column 1 Column 2
---------------...
In Access I have a form that is filled with a query and displays one record.
I want to change the current record in vba and have it display on the form. I am having all kinds of problems.
I...
I have a form (Form #1) which remains open when another form (Form #2) is then opened from a subform on Form #1. When the second form (Form #2) is about to be closed, I want to be able to call...
