Search results for query: *

I have a form called 'Occurrences' with a subForm called 'OccurrencesSub'. On the form I have two fields, one is called 'Begin' date and the other is called 'End' date. The user may enter the beginning and ending dates directly into the fields or select an option button what will populate the...

I have a form with a subform. The subform is a continuous form. The number of records displayed in the subform always varies. I am attempting to build a button in the main form that when selected would add info into a selected field of each record in the subform. This is a sales/inventory...

I have developed a report in Access. This report is designed as a label. The label to be printed on a dot matrix printer with continuous form labels. The problem: I can't adjust the page margins in Page Setup. I want to change the top and side margins to "0" but it defaults to 15.8mm from the...

I have a problem with deleting records. I have a form in my database where I have included a delete button. The delete function works perfectly with an access tables (backend). When I connect that same form to the converted SQL tables (backend) it gives me an error message: run time error '3146'...

I have a problem with deleting records. I have a form in my database where I have included a delete button. The delete function works perfectly with an access tables (backend). When I connect that same form to the converted SQL tables (backend) it gives me an error message: run time error '3146'...

I have a large procedure with a number "if" statements. I get an error message that the "Procedure is too large". Is there anyway around this or do I have to reduce the size of the code?

I have a a form and a linked subform. The subform is a continuous form. The continuous form may have anywhere from 1 to 50 records. I need to be able to delete a field in the subform. I have created a VB command: [change1]=" ". to clear the field entry but it will only clear the first record...

I have built a delete button on my page. The page also has a linked subform. If I delete the main record it only deletes the information in the main form but retains the information in the subform. Is there a way to delete both records in the main form and the subform at the same time?

Is there any way to write query a date range in visual basic? I have a date range from thats called beginning date and ending date. I want to be able to determine if a specified date falls within the date range. Is there any way to do this in visual basic. Can BETWEEN be used in VB just as its...

I have a chart with a query data source. In the query, I have placed the following under the DATE: "Between[enter a beginning date] and [Enter an ending date]". The chart works perfectly. However, I would like to place the selected date range across the top of the chart in order for the user to...

I have a msgbox that I want to display when opening a form. I don't want the msgbox to display immediately upon opening. I want a delay of about 5 seconds. I insert the TIMER INTERVAL of 5000 and place the msgbox in TIMER EVENT. Then when I open the form it waits five seconds before displaying...

I need to return the difference between two different times and dates in both hours and minutes. I am using the datediff function to calculate this in hours. The only problem is the datediff function returns a result that is rounded to the next whole hour. I need to be more specific than this...

This is going to seem very simple but I just can't seem to find the answer. I have a form that I have created that doesn't have a form header. I now find that I need to add a form header, however after adding the header, the info I have added into the header will not display. Any ideas?

I have a rostering database that I need to join a time from one field to the date from another field. Here is what I have. I have a form with drop down menus for various work shifts. Linked to the work shifts is the sign on and sign off time which doesn't change. I would like to join the sign...

I have a scheduling database and would like to develop a pop-up warning whenever there is an attempt to schedule two peole to work the same shift. I have a table with a field called ROSTERID, SCHEDULEID and a field called PATTERN. There can be many SCHEDULEIDs for each ROSTERID. There is only...

I just can't seem to locate what would seem to be a simple solution to a problem. When I create a form and include a subform, I would like to be able to include the subforms FORM HEADER to view in the overall form. However, I just can't seem to make this work. I've tried and tried but even...

I have this problem with a report in access. If I build a report but don't include a page header in the original report and later find that I need to add one, it will not display on the first page. However, it does display on the remainder of the pages but not on the first page. Any ideas?

In my access database, I have one page that can be accessed from two different locations. Is there anyway to make the datbase return to the page from which the user just came instead of to only one preselected page.

I have an access program for which I have included a few charts (Bar charts). The bar chart works great except for one problem. Access will not put a label on every bar in the chart. It normally labels every other one. Is there any way to force access to place a label on each bar?

I have several bar graphs that I have built as part of my database program. Whenever I call these graphs not all labels are visible, only every other one. I need for it to show every bar label. Any way to do this?