Search results

now I'm wondering if it is me or the site. I am registered there, so I signed in. Then I did a search on tab subform. When I clicked on your post, I got a page unavailable. I tried a different post, to make sure your post wasn't removed or something. That didn't work either. Now when I try...

I did not get a complete url, could you please repost that?

I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I work for. My issue is with good form design. I have a main form. Then I have 3 pages on a tab control ( 4 if the type of candidate validates that is is to be shown)...

I have an entry form for a candidate database. There are many combos that control things like types and listings that involve information for the candidate. For all of these types, I have a maintenance form for each of them. In the entry form, where ever a type has a combo, that combo has code...

I have posted an html of my table list and table field details. Please feel free to view this to help in understanding what I have created in the backend, which serves the forms front-end. http://www.geocities.com/misscrf/tabledefinitions.html I am currently struggling to get my entry form to...

OK, I am attaching a database here, and looking for design advice. I started this out to get the main structure set. Now the user has come to me with a complete list of fields that she wants to have that she can enter useful data into and report on. We discussed everything, and now I am...

Thanks. I actually have my db in 3rd normal form ( there are posts that explain it) I have maintenance tables, and I have now found out how to display a message to the user when their item needs to be added, giving them the option to add it...

I have a user form that is for entering in candidate profiles. There is a tab control with 4 tabs. Each tab has a subform, 1 subform has a subform within it. Each subform has 1 or 2 combo boxes, which are FK's to type or listing tables. What I want to do is prevent a user from being able...

Well, I appreciate the post. I think, as I have started to create a form with subforms based on the table flow, that I have one main confusion. I have a table for addresses - tblAddress. This has the addressid (pk), candid(fk) address1(text), address2(text), cityid(lookup to tblcity)...

This question makes me hesitant toward whether this db is normalized. Let's close our eyes and pretend it is. I would do some fields in the query builder, and name them each movie, and then do IIf (field1 = 1, "moviename", "") for each movie field. From there, on the report, just put an...

I have seen this recently, so you might try this method. Create form1. Then add subform2 to it. Then add subform3 IN subform2. This way, it is looking at what fields to connect 3 with 2, not 3 with 1. If you put form3 as a sub to form1 it wants to connect those two, not 3 and 2. Make sense?

I would just put a button on the form to open the report. I wouldn't consider a report a subreport unless it was a report within a report. When you want it with a form it is just a report. I don't know if you will be able to view it within the form, as a docked object, but you should be able...

I am by no means an expert, but let me share my method for handling this. You can either make a save record button or a new record button ( Access saves data entered the minute a record is started.) Here is the evaluation part... Onclick of the button, before the action does the command of a...

you say that you want this in a query, but you would set up the field in the table. Can you tell me about your table setup? the 1, 2, 3 is that an autonumber, or is that it's rank as a stolen car? Please tell us all fields in your table(s) and their format, what you primary key is, etc. Then...

3nf table structure, I think, now what? I have been reading up on normalizing table structures. I have this database that I am working on, to work as a hiring database. It should hold information about people applying to the law firm I work at. I am looking for advice on if this table...

why is no one answering my post? Im gonna cry! :confused:

also please show us how your date data looks. This will matter for how it is converted. I know there is a format thing if you look up in Access help convert date to string.

I have an option group that has 4 options. The options are account 1, 2, 3, or all accounts. I want to have the report run based on the choice the user selects. Why is this so hard? I can't seem to find how I evaluate the option group in the account fields criteria in the reports control...