Search results

Hi there. I have never come across this and I'm hoping for some insight. In my database I have a form that is now saying it is not updatable. I went to a previous copy of this database and the form works fine there. I took a copy of this working form (and query behind it) and replaced the...

Isladogs, The limit is 2mb for an upload of a database. There's no way I could put everything up there to run this and stay under that limit. To get an idea of what the buttons do follow the directions I gave. In design view- Go to the properties drop down box and choose anything that begins...

I made a database with just the form in it. When you open it you will get lots of 'can't be found' messages as I did not add any of the subforms. Open in design and the default page will be showing. To see how the gotocontrol works go to the properties and in the drop down box click on any of...

Yes- so sorry for the confusion-- basically the gotocontrol was used to go to a different page on a tabbed form. What threw me was that the look-- the person who designed it removed the tab look and instead used buttons for the user to tab through the different pages. Because the tabs were...

Yes (and no?)-it is similar to setfocus- you use it to go to a specific control, not necessarily subform. In my case the main data page has the list of buttons (contact info/client notes/etc) Each of the button sets the gotocontrol of the control on a different page or tab within the form. My...

Hi all, Thanks for your responses. theDBGuy- yes when typing I didn't catch that I had typed the syntax incorrectly. Cronk thank you-- I never really used that drop down in that way. So it turns out this form has many pages and that is what is being called into focus with the gotocontrol...

Hi there, I inherited a database that on it's main client page has navigation buttons (emergency contact/client notes/evaluation info/main client info(default page that opens when form is open)/etc. These navigation buttons will open and set focus to the specific subform. Each of the subforms...

Thanks for your help. For whatever reason I could not get the timer to work. However, I did find a solution on another forum, and it was quite simple. On the OnDataChange event of the first subform I put in the following code: If Me!TabControlName = 1 Then...

I have 2 subforms on a page. The first subform holds data from other sources-claims that have been submitted and paid. The 2nd subform shows all the claims that are currently in her database. The user needs to move these finished claims to her database. She can look over the data, confirm it...

I have built an import program. It pulls in all the data from 2 other systems runs consolidations and matches it by each client. The user needs to view the claims (data) from the imported spreadsheet. If these claims are not in her database, she needs append the data to her claims table. I...

Thanks to both of you. Cronk, your solution worked, until we started pounding on the form and doing several months in a row. (The reason I don't make new spreadsheets is this is linked to overwrite a txt file that needs sent for govt reports). Arnelgp, I came up with what you sent, but only...

Hi all, I am hoping this is a simple fix. I used some vb code to kick out data to my excel file. Basically each time the code is run, the new data overwrites the previous data on the excel sheet. This works, it overwrites, BUT it doesn't clear out the previous information. So say I ran it...

The If statement with the dlookup did work for this! Thanks. I've been thinking about it and I think I made it too complicated- I don't need to involve all three subforms. I am wondering if I can use an OnChange event with a Iif statment and Dlookup. Is this possible? (the where clause...

that may work. If the user will simply send the same letter to each client/partner and we do a simple cc'd at the bottom with the names of all the partners at the bottom. What she asked for was this: PrimaryClient Partner1 Partner2 AddressPC AddressP1 AdressP2 CityPC...

My data is normalized. One primary client can have many partners. It's in the table that way. PrimaryClient Partner 6 12 6 133 6 442 etc My problem is in display of a report/invoice. In the detail section is all the fees that are...

Hello, In my Clienttable we have a field if that Client is partnered with someone else. One person is considered the primaryClient and the others are partners. Most of my primaryClients have just one partner, but I have a handful of folks that have multiple partners. These folks share/split...

I have a tabbed form. MainTabForm On one tab I have a billing subform. The billingsubform is basic shows date and a field called timeperiod. The client bills by specific time periods so all bills/fees for March go into one bill- all fees for June another/etc. This billingsubform has 2...

My sql view does have the left outer join. My query for this report only has one table- the sql view. So I guess I should just add the customer table for the left join. That was my initial reaction, but I'm just getting back to access work after years off and I'm questioning everything....

Hello all, I have a search form for my user. They can pull up a report with the current balances for each customer. Works fine if the customer has a balance. I added a pop up box for times when there is no data. However, the client wants to have the report still appear with the customer...