Search results

The compact and repair worked.

It's not the DB size, it's the company policy. I removed the macro from the form. When the form opens it has (New) in the providerid field. When I start typing the new provider's first name, the ProviderID now shows 355 when it is suppose to show 606 which would be the new autonumber ID when...

the data type is Autonumber

It won't let me post it.

mike60smart...I will try. Will need to remove some information and then see if i can do it from my work computer.

Bob, I added a macro to the OnLoad event of the frmAddNewProvider. I was in the same boat as you with if I set the forms Data Entry to yes it will open to a new record. Unfortunately it kept going back to a previous ProviderID. The frmAddNewProvider is bound to tblProviders. When I initially...

I created a data entry form to add a new provider. the form's record source is tblProviders. 1. Under the Data tab for form properties I changed Data Entry to Yes. 2. The On Load event I set the macro to open frmAddNewProvider with the gotorecord set to New 3. I added the fields for...

I will have to look into lookups. I saw this when I used the Analyze Table but I didn't understand it, and plus it separated fields i believe should have been put in the same table, i.e. emobile, emobileactivationdate, emobilecode. All three were in different tables so it didn't seem right to...

Minty, Thanks for the reply. I do understand the recommendation regarding the Contact and practice tables. One practice can have many contacts. The only thing I am confused about is moving the PracticeID_PK to the other tables. The ACO, Dept, PracticeStatus, etc. are Yes/No or a certain...

i have read up on normalization and attempted to put what I think I learned into action. Can someone look at my screenshot and let me know if I am close? Thank you in advance

will look into it again

I tried it like that, but I kept getting confused on how to link the two tables. I'm still trying to figure out how to do relationships.

I didn't capture it in the screen shot but the ID field is MUID_PK | AutoNumber. Would I break this table up into different years or just add on to it? It seems easier if I just add on to it. Then I could just query off one table. Or is that not a good thing? Just asking for future reference.

They are separate fields. Yes or No responses. They run reports to see how many providers are actively using a certain product.

I was wondering... In my database i have a table of providers, tblproviders, which captures their name, credentials, join date, end date, and any products they have activated (such as emobile, emessenger, eHx, etc.). Each provider is part of an incentive based program and we need to capture...

Sorry Cronk, I am just trying to understand all the suggestions being presented. I am not an experienced developer and a beginner at using VBA. For the most part I just use a lot of MACROS. I try to do a lot of research on this before I start asking questions but I can't view some sites here at...

I seen a youtube video where he added the reports to the table and had a field name for the report. Unfortunately he was speaking in a different language so i couldn't understand why he was doing it that way. I can try and mimmick and see if that helps. At the moment I just created a Form for...

Would this be added to the OnLoad event? Is there a link that shows or instructs one how to filter on the status? Would this be the right click > Text Filters?

Is there a way to open the report the user selected in the combo box? I created a form with a combo box (cboCannedReports) and listed three reports: 1. Completed Closures 2. Pending Closures 3. All Closures I came up with something like this DoCmd.OpenReport...

That is exactly what I was trying to say. I thought about creating a separate form for the click event on the record selected. I was just thinking maybe i can direct them to the form >page/tab i already have.