Here is my delema. I work at a command that is using a massive and horribly inefficient and unfriendly Access DB to track student records/grades. It can take over 10 minutes to input something that would take less then 1 minute. I am trying to make life easier for my circle of co-workers my creating a simple, user friendly excel workbook that can put its information into the access DB. I can ensure the the DB is already open before running my macro, and inputting directly into the tables is out of the question. The dual program interaction is where I am getting stumped. I assume I need to do an ADO connection which I'm pretty sure I figured out, but what I need help with is the following...
1) Is any active program (like activesheet) needed when bouncing back and forth...if so, how
2) How can I put a cell value into a textbox/combobox on an access form...I've already verified data is valid and in correct format
3) How to "press" a command button on an access form
Basically, I'm trying to use/input the access DB in the same fashion as an actual user would, but have it be automated with VBA. Any help is greatly appreciated.
I'm using Office 2007
Hi!
Ted here, I need some help with a form and some macros.
Here is what I have I have a data entry form (frmNewOrder)where I enter the customerID then I go to a combo box which says Air Freight or Sea Freight what I would like to do is that when Air Freight is selected have the Air Freight Data Entry form open (frmAirFreightordr) and then copy the customerID to the field that says CustomerID in the Air Freight, and Sea Freight is selected then it opens the Sea Freight Form (frmSeaFreightOrdr) and copies the CustomerID that I input to the CargoDetails into the customerID field (which is related in both forms)
I can't have one big form
This is because there are three seperate tables
one for Cargo Details
one for Sea Freight and
one for Air Freight
as one order for cargo can only be sent through one means of transport (Ie Spare parts for a refigerator can only go go either by shipping or plane)
One the Cargo Form first of all on that form I input the CustomerID
Then what I want to happen from the drop down menu when I select the the attribute Sea Freight the form for Sea Freight Details will popup and the same would happen when I select the Air Freight just the Air Freight Form would pop up.
When either of these forms pops up I want it to have the CustomerID from the Cargo Form to copied onto whichever form pops up (Sea Freight or Air Freight)'s CustomerID field.
Could you please help me with this? I would greatly appreciate some help thanks,
Ted!
Hi, i have a problem to find the best way to print data(numbers and name) on blank form which looks like this:
http://img516.imageshack.us/img516/4852/imgxv1.jpg
To be exact, i want to print some numbers and names in those columns (column names are on serbian, and it doesnt matter whats the translation), but i must align it perfectly, so is there some program or trick in MS Office(using word or excel, or maybe Publisher) to do that!
Thanks in advance!
We use many forms linking to subforms, many times with more than one form open at a time. At times access will 'flip' users between forms unexpectedly. Any ideas what may be causing this?
I'm using Excel 2003 SP2. I have a requirement to send +- 155000 records to
various external parties. I want them to add to the data which I send them,
but not to modify any existing data. The spreadsheets contain 60 fields of
which the first 28 should remain untouched. I have exported the data from
Access and therefore all data per row is related (as in a database)
I would like to have all the data in one workbook. Because of the number of
records I will have to split it into 3 worksheets.
I need to enforce some data capture rules for the columns I want added.
I need to know whether I can use a form of some sort (I read that data forms
are limited to 32 columns and therefore that is not an option) whereby users
can select their own relevant records and capture required data.
Can I protect the 3 worksheets which hold the data?
I would appreciate any assistance, advice or comments. Thanks
I am writing an excel workbook to keep track of a local festival's finances. This workbook is used for logging all invoices and expenses.
What I would like to do is set up a table or list of all invoices etc. Rather than an empty table below which doesn't look good, I'd like to insert a button labeled 'Add new item' which once pressed will create a new row underneath the headings, and then a new row under that and so on, rather than filling in the cells manually. I'd also like a dialogue box to appear once the 'add new item' button is clicked with boxes for date, who to, paid etc etc so that the recently added row is completed automatically. This is a bit like data forms, only it is intended for novice users so I'd like it if it was macro driven so that the user doesn't have to play around with the excel ribbon.
If anyone can solve my query it would sure help out a lot.
I dont know if i am posting this in the correct forum but here it goes. My code reads like this
Code:
Sub()
ActiveSheet.ShowDataForm
End Sub
This works great but it always goes to the last entry that i put in using the form. What i would like it to do is always start with a new entry instead of having the user have to press the new button on the Data Form.
Just wondering if this is possible
umrebelfan69
Hi Y'all,
I have a spreadsheet without about 20 column headings and I'd like to use a data form to enter data into it, for ease of entry.
When I select the data and hit the form button it allows me to view the records but it doesn't allow me to enter new ones?
Also within the spreadsheet there are a few data validation lists to ensure the users pick from the pre defined list. The data form doesn't offer a drop down list?
Any suggestions?
Thanks,
Jay3
Hi I have a spreadsheet that I am filling in using a form.
I have also a row at the bottom with blank rows in between
with a running total. When I print there is a huge gap
between the last entry in the form and the totals at the
end. Is there a way that the form can enter the next line
and push down the totals so that there are no gaps.
This is what I have.
Name Salary Tax Total
Ann 42000 5000 37000
Joe 37500 6000 31500
Total 79500 11000 68500
This is what I want
Name Salary Tax Total
Ann 42000 5000 37000
Joe 37500 6000 31500
Total 79500 11000 68500
and then when I add new info with the form it can push the
total line down and calculate as normal. Is this possible?
Thanks
Ann
