Hello,
I would like to issue a system command from within a VBA function. Specifically, I'd like to start another application using a command-line startup command, but am not sure how to do that.
Any suggestions?
Tom
Does anyone have a source that lists basic Access (2000) commands. I have training in SQL server (so I am just starting out) but I am working with Access and the commands aren't always the same and the help files in Access aren't much help.
My immediate need is to find the equivelant of the go command. I am trying to build one query with multiple update statements.
I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.
View 2 Replies View Relatedhi,
i need serious help with my access project...
im designing a database for videoshop for loans in access. i have got my movies and loans tables (along with others) and have got them as a one to many (loans to movies) and have got Rental ID as Primary key in Loans table and got that linked to Rental ID# in movies table.
i want some sort of command in the loans form so that when a customer loans out a movie it will update the movies table (rented out field).
the fields that i have got in the loans table are:
Rental ID
Customer ID#
Movie Rented Out
Date Rented Out
Other Rental Details
Rental Duration
Daily Fine Rate
the fields in the movies table are:
Movie Title
Movie Quantity
Movie Description
Genres
Rating
Director
Popularity
Rented Out
In Stock
Supplier ID#
Rental ID#
Stores ID#
if anyone whos reading this knows how i can do this then it will be highly appreciated if u replied to this thread.
thankssssssssssssssssss.....
adeel.
i have a subform which appears on numerous forms,
in this subform thereare fields with dbl_click commands to open other forms
however, on one parent form where this subform appears, i wish 2 queries to run prior to the form closing
i have one way, which is very messy, and involves updating unbound controls to feed iif statements
is there another way thru utilising some public functions, and or active screen properties, that would be more efficient.
many thanks
Hi all,
I was wondering if you could use custom menu bar commands to open reports and varying the recordsource of the reports according to which command you choose. For instance, if the user wants to view a report for January, he clicks on the January menu bar button. And I do not wish to use macros as there might be many macros to use.
Was looking at it and I am able to use my own vb functions but was wondering if I could use the tag field under the customise menu bar command to specify which records to filter to?
Maybe I should just use a form with all the code behind. lol... :p
I have created a query that has the info for a quick search. What I want to do is create a form that I type the last name of my customer and then click a button that opens the query and filters out all records that don't match the criteria I enter. I want the button on the form to do both. Is thie possible? If so how? Please Help. Very much appreciated
Biz
There is one table Name "Menu"
Code:MenuTitle MenuCommand----------------------------------Add Customer docmd.openform "frmAddCust"Print Customer docmd.openReport "rptCust" ,acpreview
Know i want to execute menucommand when i select menuTitle in listBox.
Please Help How can i do this.
Integer
I have been working on customizing MS ACCESS to
produce a report that involves one mathematical
computation from my input data. However, I've run
into a problem because I can't get the program to
carry out a logic command that would work fine in
MS Excel: the "IF" command. Specifically, what I'm
doing involves a calculation, where one data input is
subtracted from another data input, but if the difference
is a negative number, I would like to substitute the value
of ZERO. The closest I've come to achieving this is to
enter the condition ">0" while in Query Design mode, but
the problem with this approach is that if the difference
is a negative number, the report does not display the
data that resulted in the calculation of the negative number.
In other words, I want the data to be included in the report,
but I want a "Zero" to be substituted for all calculations that
produce a negative number. For example, if I enter a set of
data, and the two numbers that get subtracted are 40 minus
36, then the difference is positive 4, and so I want a "4" to
be displayed; But if the two numbers to be subtracted are
36 minus 40, the result is negative, and so I'd want the
report to display a "zero" in the calculation.
Please advise me on how to set this up, as the only approach
I've found resulted in all negative calculations being omitted
from the report.
Thanks for your help.
I was quite familiar with DOS commands and was able to create access DBs and write the VBA button code. However that was quite a few years ago and Ive forgotten it all.For every image file in DIR A or subdirectory If that image file exists in DIR B, then delete the image in DIR B.
View 3 Replies View RelatedI have a custom menu bar that has a couple of menu lists, with a list of five custom commands that i want to run,depending on what is selected.I know you can assign a macro to each command,but is there a way to know which command has been selected.
What i want to do is to have 1 macro that will run several functions depending on what was selected, rather than 1 macro for each button
Zooming commands when working with relationships
1.Im wondering why there is no option to zoom in and out as we are working with relationships.
2.And even the option show all is not working; some of the tables in the relationship are kept hidden (screenshot is attached)! How could we work in this environment?
3.I do know the I can use the scroll bars, but they are not enough to perform the work more professionally
These features are available in most of the software!to zoom in/out To pan .To zoom all (extent Where are they in the relationship in Access?
I've been creating an automated way for users to import an existing DBF III file into an Access Table and then I'll be doing some other things after it's in. The user needs to be able to click a command button to open up a file picker, select the desired DBF and then click import and have it be imported into a new table.
Originally I had this all working because there was only one possible file name for the DBF file in each folder so instead of using a file picker I used a folder picker and supplied the file name in the VBA code as it was static.
However, I now need the user to be able to select a specific file and the name could be anything.
I've successfully edited the file picker to allow them to select a file however the importing is an issue. In order to do a TransferDatabase command I need the file path alone for DatabaseName and the file name alone for Source.
What would be the best way to split those two pieces of data up once the user has selected the file they need?
tell me that can we use functional keys F1, F2,F3,,,,,,,,,,,,,,F12 in ms access to perform commands like saving a form data , for closing form refreshing form, clear form.Or is there any way to make shortcut keys combination like[(ctrl+s)(ctrl+c) (ctrl+A)] in access to perform action like saving,closing,clearing, current form.
View 1 Replies View RelatedI want to run multiple SQL commands on click of a button. I have these three command,
CurrentDb.Execute "INSERT INTO UserMadeDeviceT(Product, ORESector) " & _
" VALUES ('" & Me.D_NewDeviceTxt & "', '" & Me.D_ORECmb & "')"
CurrentDb.Execute "INSERT INTO UserMadeDeviceT (RatedKilowattPower, KilogramWeight)" & _
" SELECT RatedKilowattPower, Weight FROM UserSelectedComponentT " & _
" WHERE [TotalComponent] = '" & D_ComponentNameCmb & "'"
CurrentDb.Execute "INSERT INTO UserMadeDeviceT (Cost) SELECT SUM (EuroCost) FROM UserSelectedComponentT"
all of these work indevidually and return the correct value but the add three rows to the table. How can I combine these three commands into one so that it will only add one entry?
I was asked to create a table within an existing database using these SQL commands;
CREATE TABLE Vehicle (reg_no TEXT(10)
CONSTRAINT VehicleKey PRIMARY KEY,
type TEXT(10),
purchase_date DATETIME,
last_service_date DATETIME, mileage_at_last_service INTEGER);
I was told to save the query and check the new table had the required records in it.
I had huge problems when I tried to save the query and kept getting error messages like: "query must have at least one destination field" and "syntax error in field destination". This was strange since I was sure I typed the query exactly as it had been written on the worksheet.
Having not changed the SQL command at all it eventually worked when I skipped the 'save query" stage and just went to the "run query" stage. I still don't know why it actually worked in the end and why I kept getting error messages.By running the query am I supposed to just click on "RUN" or can I check the information first by looking at datasheet view?
I have a button on my form, that runs a series of queries then closes the form. It works great!!
How can I get the MsgBox feature to continue with all commands or cancel and close the form?
Here is my code without message box action
Private Sub AcceptChanges_Click()
DoCmd.SetWarnings False
Forms!SelectCustomerNewCustomerF!MergedRecordsF!CustomerID = Me.SecondID
Forms!SelectCustomerNewCustomerF!MergedRecordsF!MergedTo = Me.IDprimary
Forms!SelectPrimaryNewCustomerF!MergedRecordsF!UserID = Me.UserIdChange
DoEvents
[Code] ....
All of these actions work great, and do not need to be modified. it is just a msg box button to continue or cancel and close the form.
I have had my 4th SQL/APP Dev lab class, however I missed the 5th.
Our 5th lab was .
1. Create 3 tables, populate with given data and create relationships. 'Customer, Invoice, Payment'
2. We were given 8 queries to try do, we had to come up with which commands would be used.
I have no 1 completed.
As for no 2.. we are still learning all the commands, so the lab here is for us to find what commands we think will be used. I have researched and have them all 6 queries we have to run.., I have all those commands written out on paper which I think are answers..how to find the command line to test them.
I'm using Access 2007 on Windows 7.
I need to send commands to an external device using a serial port.My understanding is that that I need to select the reference to the Microsoft Communications Control (MScomm32.ocx).But is not available in the list of references!
View 2 Replies View RelatedI wish to create a forms that has command button which display a drop down list. The drop down list should contain commands for reports and forms.
Lets assume we have forms named FrmStock, FrmSales and we also have Reports named RptUserLog , RptTurnover.
I am new to Access and Ive created adatabase to control a spa system.
I have several tables: Customers
Employees
Types Of Haircut - Their prices
Types oF massage Their Prices
Now I want To create a form where i am able to choose customer, the employee performing the haircut or massage
The price should be displayed and the total AMount
How can I do that?
Should I create a Query and based on the query I create the form?
Please Help!!!
Thanking you all
I am still a bit confused about the system.mdw file.
I create FE and BE on my local computer and change name of system.mdw to say Jobs.mdw, after backing up system.mdw I then join jobs.mdw with my jobs FE and jobs BE and set secutity settings, etc. I then place
FE, BE and Jobs.mdw all in the same folder.
I now email jobs database with jobs.mdw file to client which places FE, BE and jobs.mdw in Jobs folder on server. Shortcut for fe is placed on each local machine.
My question-Does Jobs FE and Jobs BE still access Jobs.mdw even though placed on another computer and possibly another version of Access?
Does the shortcut have to reference Jobs.mdw?
I need to understand this.
Thanks,
Jim
Hi All,
Need your expert advise. Is it ok to develop a simple payroll system using MS Access or do i need switch to Visual Basic?
Also, is there anybody can help what tables do i need to produce a payroll system, i.e. tblEmployee.
Thanks,
19Summer95
I am creating a database to room allocation in a small hotel. I want the system to check room availability between two dates. What would be the best way to construct this in Access?
Kev
Hi, I am trying to implement my Database with an enquiry (or quotation) table and I am not sure I am heading in the right direction:
-We use assemblies made of components and the data are held together in the database with a 'Bill of Material' set up.
-A typical assembly is made of 1 or 2 bodies + Fasteners (straps and screws),
-The body price is calculated depending on his weight and an extra costs can be added with extra tooling and machining,
The costumer ask us for a quotation for various number of assemblies and we send back the estimation of the price,
I am really struggling to see if my tables are set right and this is what I came up with (attached rr.zip):
A main Enquiryfile Table is linked to an enquiryDetail Table which would record each individual item information for each Enquiry.
I have also added a Extracost detail table that would record all the Machining and extra pattern making cost for each assembly.
And finally, and that's what I am far to be sure about, a TblChildItemCost where the price of each components would be recorded (for each enquiry detail). The body price is based on his weight but also depend of various market exchange rates, that is the reason why I have created a table for the price of component for each enquiry.
I really hope someone can help me on that one...Thanks in advance.
Hello,
My application I develop should retrieve some meta data from Access system tables. It should find:
- What tables are stored in database.
- What columns have each table in database.
- What relationships are between tables in database.
I opened systems tables of some .mdb file and took interest in such kind of information. But I got some problems by looking for what exactly I need. Please, could someone help me at these points:
1) I found that in system table MSysObjects I can find names and ids of tables created by user (for example by me). But how to determine that these tables are created by user and they are not let’s say a system tables?
2) I didn’t find any meta data about columns of tables! How to determine what columns has each table?
I created application which uses MS SQL Server to retrieve such a kind of meta information and there where no problems. But I stuck using Access.
I was looking for some information in Internet but ineffectively. Please, help me...