Search results

Automatic Export of a Access 2007 in a fixed width Delimited format. I have a program that I need to export a table T_ExportToAccounting that I need to export in a delimited format on to a floppy disk. I have read through the posts and solutions but still don't understand how to do this. The...

Hi I am looking for a book or poster or something that can show me all the access controls and what they do. My VB.NET version came with several posters. I have looked at many books but can not find one that enumerates and explains all of them. I would also like to get similar information for...

Hi I am printing tickets and need my Star Micronics TSP600 to cut after each ticket or after each batch of tickets. I could do 2 things. I could make the printer cut through code or I could tell Access to split the tickets in half and make 2 reports or 2 pages. Example if I want to print 3...

Anyone know if Access 2007 has control arrays or some thing similar? Thanks

HI I am working on a touch screen app. I need to make the drop down arrow in a combo box bigger so the user can choose it easier. Any ideas on how to do that. I could just put a transparent button over the top and make it bigger but I don't know how to call the click even for the combo box. I...

Hi:confused: This code error is a bit complicated so I hope I can explain it properly. This is from a ticketing program I am working on. When the user clicks one of the buttons, say the adult button, the ticket type, price, qty, and total appear in a list box. One click on any button adds one...

First off thanks to everyone for all your answers on my previous questions. I have an on screen (touch screen) number keypad. Is there an easy way to have this key pad enter numbers into the current txtbox? I have several txt boxs so the the key pad will have to know which one has the focus. Thanks

Hi This code error is a bit complicated so I hope I can explain it properly. This is from a ticketing program I am working on. When the user clicks one of the buttons, say the adult button, the ticket type, price, qty, and total appear in a list box. One click on any button adds one of that...

I am trying to make a program to sell tickets. I need to figure out the best way to display the running receipt on the form. I would like to have it so that I can choose an item from the receipt section and delete it or change the qty. Is there any tutorials or sample databases that have some...

Hi I am creating a program that will be used with a touch screen. I am not sure what you call the button you push to get the combobox to open. I want to make that button bigger so that it can be used more easily with touch screen. I also need to know how to change the background color... not...

Hi I have more questions on this ticketing program I am trying to get working. I have buttons along the side of my form for increasing and decreasing the number in a text box which represents how many tickets the customer wants. I need to take that number and display it along with the rate and...

HI here is a crazy simple question I don't seem to be able to figure out or find an answer to. I have a program I am making in Access 2003. On the form I have a text box it is used to display the number of tickets sold. I want the user to be able to click in the textbox and enter a number...

Hi :) I am creating a program in VB.NET with an access 2003 database. This program will be in 2 physical locations. This is a program that sells tickets. At the end of the day I need to be able to get that days sales data off the remote location and update the main location with that...

I have a form with 6 combo boxes at the top. Then I have 3 sub forms with 2 or 3 columns each I have the tab order set up so it cycles through the top 6 combo boxes adn that works just fine. But when I go to tab into the sub forms the tab order is never consistant. I set the tab order of the...

:confused: This will be hard to explain. I have an access program that will log punch in and punch out times. I need to be able to create a new query or what ever to search for a how many people are punched in at a certain time over a given spread of dates. example the user wants to enter...

Hi I have an access 97 project that someone else wrote some time ago. I need to install this program on a new computer for someone. They want access 97 installed on the new machine also This "file" is just a .mdb file that they are using. no install stuff.... When I open the file on my...

I want to put a Year To Date total on a report. The report is a daily sales report for a particular month. It will show sales by day for 3 separate shops for the chosen month. When the report opens the user is asked for the mm/yyyy Is there a way to pull out the YYYY only from the dialog box so...

:confused: I have a 2 combo boxes that display the date and time respectively. They default to the current date and time. After a record is entered if I go back and single click in these boxes I get the full time…not the short date as selected. I have short date selected in the form, the DB...

:confused: I have a small access program. It has no modules and only 2 forms. The database has 1 detail table and several smaller tables that hold info for combo boxes such as city names, customer types ect… The Database will accumulate about 30,000 new entrees each year. Each entry will be...

:confused: I have a small access program that I need to put on a network. It will only have one user. The Network administrator insists that the DB be on the server for backup. The DB will have about 25,000 new entrys each year. There are only 2 forms. Data entry with several combo box's and...