Search results

I have the following date calculation : ----------------- Private Sub StatofLimits_GotFocus() '--Determines Statute of Limitations accounting for minors. If DateAdd("yyyy", 18, Me.Txt14) > Me.txtBegin Then Me.StatofLimits = DateAdd("yyyy", 20, Me.Txt14) Else...

I have a db for my LawOffice. Is there a reason/advantage to create and send form letters as Access Reports instead of just using Word directly? I can't see any but maybe I am missing something?

I realize this sounds like it should be posted in the Report section but I am posting it here because I suspect the answer will involve coding or modifying my forms. I have multiple tables with bound data input forms for my law office db. One of the items recorded is due dates for different...

I have a multiple row of tab controls on a form. I need to add another tabcontrol in the middle of the row. Is there a way to do this? Every time I insert a new tab Access inserts it after the last tab. I have searched for a way to reorder the tabs but haven't had any luck.

I have a multiple row of tab controls on a form. I need to add another tabcontrol in the middle of the row. Is there a way to do this? Every time I insert a new tab Access inserts it after the last tab. I have searched for a way to reorder the tabs but haven't had any luck.

This is so basic I am almost embarrassed to ask but here goes. I have two subforms bound to a 8 field table. Subform 1 fills in 5 of the 8 fields and subform 2 fills in the other 3. I fill out my main form bound to Table1 then open subform1 and fill in the 5 fields. This subform is linked to...

I have a form with a combobox based on a query of a lookup table. If the name entered is not found in the combobox, I want a popup form to open allowing the user to enter a record for this new name in the lookup table, then close. What is the best way to this? A command button? The Not in...

I have two forms bound to different tables. I will use an example to illustrate my problem. I have 4 people who have each sent me 5 documents. I do not currently know the identity of these 4 people so I can not create a lookup table. In the future they will continue to send me docuements. In...

I read somewhere that you can have more than one row of tab comtrols on a form. I have searched the forum for any threads or posts on the issue but can't find anything. Does anyone know how to do it?

We currently have a spreadsheet to track all of a clients medical's bills and keep a running total? I'm trying to decide whether to continue to track these medical bills in the spreadsheet or create a table and make it a part of the client db. I'm leaning toward keeping the spreadsheet. It...

I have two tables in my law office db.(for purposes of this question). The first is a clientinfo table which is populated by a clientlinfo form. Then later on I have a table which stores the info on the defendants in each legal case again populated by a form populated by a form. I need to be...

If I have a form and seversubforms in tabcontrols where the relationship between the underlying tables to which the forms and subforms are bound is one to many? In other words, once I enter the data for the record on the main form and go to the subform in the first tab can I enter data for ...

I have a combobox that looks up casetypes in a lookup table. I coded the after event property to open up the form for the form selected. so if the user selects autoaccidents the autoaccident form is opened. The combobox is also bound to the caserypeid field so that the current form will save...

I am using a DLooking Statement to pull a persons birthdate from another table and populate a unboundbound text box in my form bound to different table. This statement appears to work and pulls in the create date. I say appears because it put a # on either side of the date it pulls in-ie...

I have 2 cascading combo boxes . The first lists the 50 states. The second lists the cities and zipcodes for whichever city is chosen. The query for my first combobox(cities) has 2 fields: stateid and state The query for my second combobox(cities) has 4 fields: CityID,city, zip, stateid...

I probably should have asked this question before now but better late than never. Recently, I got a coding error that completly locked me up. I had to do a hard reboot. When I reopened my db every line of code in the db was gone. Fortunately, so I thought I had backed up the db. So I opened...

I am using the following code to update my form, open a new form with a new record and then populate certain fields of that new record with data from the previous record: ------------------------------- Dim strFrm as String strFrm = "frm_Auto_Accidents" 'save pending edits Me.Refresh...

I have lost my combobox wizard when I create a combobox on a form. When I drop the combobox on my forms I do not get the wizard allowing me to set up the box. I have to go into the properties window and set all the settings. This happened to me once before. Does anyone know how to fix it?

I have a client db for my law office. After client info is entered the db branches off into one of 4 tables depending on whether the legal matter is a state civil, statecriminal, federalcriminal or federal civil matter.the db the continues from of these 4 main tables. I have a client contact...

I have a calendar on a form. I actually took it from one of of the sample calendar dbs here on the Forum.(As an aside, the sample dbs here are great. Thanks to those who take the time and trouble to write them)My question is can I put more than 1 calendar in my db-ie I have other forms that...