Search results

No worries. I found the solutions.

That is correct.

I see what you are saying. So I will be tracking 10 milestones in the db and none of the projects in the portfolio of accounts will have more than 10 milestones. For reporting, if there is less than 10 milestones, I will be playing with shrink, visible, grow etc. properties of the fields (for...

Thanks for the tip. However, requery didnt solve the issue but I was able to find a work around as follows: I created a tiny form (see attached) with just 2 fields and then i added a button with a label 'complete project details' and included the following steps in the macro for that button. 1...

Its already set to 'yes'

I have 'RecordID' as a primary key on one of the tables which is linked to other 2 tables - see attached I have 'RecordID' as Master and Child fields in the subform.

Yes, the record source for both the main form and all subforms are queries and i am able to edit all records.

All fields are inside the tab control and then inside the subform for each of the tabs. 1 - when I put the command button and used the wizard to create a new record on the main form (under page header) it gave me a message "you cant go to the specified record' 2 - when i put the command button...

Yes. I have a main form and then a big tab control with 5 tabs (pages) and each page has a sub form. I tried putting the fieds in the tab controls without the subform but when i dod that it would not let me edit any of the fields which is why i had to put a sub form under each of the pages...

Hi, I have a form and in there I have a tab control with multiple pages. The db has 3 tables (one-to-many relationships). Question: How do I add a new record in the tab control? When I try to add a button in the form, it doesnt work and when I create a button within the page of a tab it...

Thanks - when I delete the values from the combo box and tab away from the combo box, it shows all results (removes the filter) but when I use the command button to clear the values from combo box(es), it does not populate all results (removes filter).

Hi, I have the code below to filter results based on the combo box values. When the clear button is clicked, it clears the values in combo boxes but it does not show all results. I tried the code below for the clear butoon but it didnt work either, any thoughts? -- Me.Filter = "" Me.Requery...

Yes, I see your point. I was in fact able to build the relationships and i am now using three tables. Thx

OK - I see why multiple tables is recommended thx

I dont need 255 fields. I was saying that this is the max fields allowed in a table. Thx

I greatly appreciate ya'all for the responses. I think I need to clarify a few things. I am building this database just for the purpose of capturing the project related data for reporting - thats it. I will have a few queries and a few reports based on the fields on a couple of forms. The...

Not sure if I will have repeated data. Each field will have a text stored or it will either be blank. Am i missing something? thx

Hi, I am building a project status database where I have 3 tables. 1 for basic project info. second is about timelines and 3rd is about dependencies. I have close to about 100 fields. I am having a hard time creating relationships. can I not put all fields in 1 table? What are some of the...

Hi All, I am building an access DB with 3 tables. I need to be able to link the tables to the sharepoint site and users should be able to use DB form to update records in sharepoint. In the beginning, i was planing on creating one table for all fields but then I realized that I would have to...

Just wanted to post a quick update on the above issue I was having. After my last post here, the problem still existed but it was happening less 'frequently'. After some more research, I think the problem is now fixed and it hasn't happened since I made the change below. I had only one...