Search results

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...

Still no answer I still have no answer for this question. If anyone has any suggestions I would appreciate it. Thanks :D

Yes Date and Time Yes In another Query I do the date diff thing so if some one punches in at 23:30 on 01/01/2004 and punches out at 01:30 on 01/02/2004 it will count as 2 hrs not a - number. so yes Punch in and punch out are date/time togather. Thanks for the reply

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...

Ok Thanks Ok thanks It's a start

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...

no it is from the query I think. That is where I enter the between [Start date] and [End date] When I run the report it is based off the query which then fires and brings up 2 dialog boxes. The first is Start date the second is End date I dont seem to be able to find where the code is...

Ok .... dont mean to be dumb but I dont even see where I can access the code for the input box. I set up a query and type Between [Start Date] and [End Date] in the criteria box. And it just creates a dialog box. That is my problem I dont understand how to see/access the code for that...

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...

Main form In the form I right click on the txt box and choose properties then default value and have =time() and = date () respectively. It still will come up with date and time for both if you single click in the txt box.

Oops Oops Sorry my bad...you are correct it is a txt box. I use a txt box because at times the user will be entering data from a printed form and they need to have the date and time on the form. Thanks :D

: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...

oops Yes... Sorry...when I hit post the first time I got a windows error that booted me off the net....I didn't see that it had gone through because it did not pop up on the top of the list. I will be more careful sorry again

I will not be the one using it. The user will not be involved in saving the info to the DB on the server. Could I set it to syncronize once a day or something? The easierst way to do it .... I think is with the splitter but I am concerned 2 years down the road the DB will be to huge it will take...

: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...