Ok, I have created a form with various fields. I would like to make certain fields required information. In other words a certain field would require you to...

Hi All I have a form that has a subform in it. The form is set to show a single form in the properties, so that it can have a subform in it. The subform adds a...

Hi All I have a form that has a subform in it. The form is set to show a single form in the properties, so that it can have a subform in it. The subform adds a...

I put down "Between and " in a query criteria to select a range of data and then I create a form to view the result. Is there any way the FORM can show the...

Hi All I have a form called "Visits" that has a subform in it. The subform is set to continous forms and is called "SF-VisitDates" and has a field called...

1) I have created a subform "SF-VisitDates" in a main form called "Engineers" I have managed to display a calculated subform value ("=Sum()" from the subform...

Hi all I need to check for no duplicates as soon as I leave the first field and not as I try to save the record. Is there any way of doing this. Cheers Ken

I have a form that creates new OrderNum and Order information from users When they are done entering info I have 2 cmd buttons Save and Delete cmd save works...

I have a form that I want to set a text box so I can use it to sort on. I tried to set the Me.orderby = "txtbox" but this resulted in an error. I then tried...

I thought I could use COUNT to count the number of checked Yes/No boxes on a form. Example, if Yes/No check box used to track orders sent, I thought I could...

Hi, I hope you are having a great day. I have form w/Form Header and Page Header. When I open form, Form Header is visible but Page Header is not. I thought...

I would like to set up two text boxes in a form with drop down calenders. This way a user would select a date from the calender. Any ideas? Thanks

Hi, I have created a top level form with two subforms. The top level form has it's own table and each of the subforms have tables. When I add a new field to...

Hi, I'm trying to set up a form and subform based on two tables with DEPTID as primary key in both. I'm using an AUTONUMBER field in main table to increment...

does anyone know if it is possible to make a memo field auto-return and expand the view instead of going on and on in one line? Thanks in advance Ken

I need to create a button which is allow the user to click and save the current record in the snapshot format in C:\POSnapshot dir for use to attache to...

I use "stations" in road construction. they are basically feet or meters from the start of the job, but in the format of ##+##.## for feet (based...

I've seen Access applications in the past where forms have the appearance of a group of stacked file folders. Each tab at the top contains the name of another...

For whatever reason my form's detail section is starting scrolled down. I want it to start up showing the top, and the user can scroll down if needed......

I'm trying to do this. I know about adding codes to the switchboard code, but I have no clue how to apply this to getting the query desing app to open. I know...