Search results for query: *

Thank you Tiffany for your comprehensive explanation!

I should clarify that to 255 fields in one single table i.e. Table specifications Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048. The actual number may be less because...

Thanks Byam, these are all new entries to the database and no existing data will be changed so I think I am okay on that. For the other thing about the max number of fields I don't work on the server so am not sure if we use "Post" or "Get" but I found this site...

I have several online forms used by about 6 different departments that feed their results into the same database table (Access database). Some departments have a slightly different form so some of their results will go into a different field than others. Would this create any conflicts and what...

I have an online form used by about 6 different departments that feed their results into the same table (Access database). Some departments have a slightly different form so some of their results will go into a different field than others. Would this create any conflicts and what if per chance...

I have a form that also has a subform on it. The problem is that when I click a command button to print the form, the form prints ok but then Access closes down. Any ideas why it might be closing down? I have several other forms in the same database that print ok and do not have that problem.

I have an Access form and I would like to have some fields open as blank fields. Currently when the form opens it displays data that was previously entered. I tried using the forms data entry property but that does not work because there are some fields that I do want to open with data. I...

Fneily, yes the combo box does have a default value however when I enter what I want to show as default it is replaced by #Name?. The combo box is in a subform which has a list of interviewers that is drawn from a table (actually the combo box builds a query to that table). If that field is...

Is there a way to make a combo box disallow the first choice. I can do this in combo boxes using Front Page but I do not know how to do this with Access. The combo box I have is a list of names of people who will be conducting interviews but the combo box will show (Interviewer) when it opens...

Greg, I'm a little confused as to where I should place the code: dim frm as form frm = forms!interviewers!<name of subform control>.form

I have a main form called Interviewers and a subform called Ratings. The subform also has a command button that is a date picker. The field it updates on the subform is called Date2. The On Click property of the command button is set with this...

Thank you Judge you have been most helpful.

I have a date picker calendar that is on a command button and is used to select a date for an Access text box form field that sits next to it. It works fine except that I would like to have it open and update that field to todays date. I tried setting the default value of the field to = Date()...

Thanks you Jeremy you have been most helpful :-D

I have an employee database that I would like to put into a shared folder to allow Department Heads to view data on employees in their department. However the Department Head should only be able to view data on his/her employees. Is there a way to limit users so they can only access certain...

I have a form that I would like to put online to collect data about physicians in our hospital. The forms results will go to an Access 2000 database. I would like the user to be able to complete the form with data for 5 physicians on one form. Essentially this means that 5 records would be...