Activity Stream

moke123's code would make it easier for you to add this functionality for other combos; for the code in post #12 please try to add "DAO." to the...

Having done a couple of QS types of db's (ISO 14001 and ISO 9000) then can definitely say it's possible. If you want it to function well, you have to...

Hi As far as I know with my limited skills your subform to display the 7 Dates and the associated Totals in the format you need is NOT possible. ...

Hello Mike, I have added 1 meter more column in this sub form (frmgreyofferdates) due to which again it is giving wrong total offer number. The...

If you are doing these repeatedly, you should use a generic sub ' usage..... Response = AddNewToList(NewData, "tblCities", "txtCity", "Cities")...

By reading about db design at table relationships. Do you envisage the db being use on just a single computer?

No necessary hard, providing you put the work in first To quote my advice to another poster: a good developer will spend some time with the...

That worked. *Sincerely appreciate* the help and input ..!! A few more of these are off as well, in much the same way. As follows from...

Look at my latest post, replace the Markets with frmMetro.

Yea, I only use an autoexec macro on startup, nowhere else. Can't execute subs from there however, they have to be functions.

Seems to have gotten farther along, but now stalls at .. DoCmd.OpenForm strDocName, , , strLinkCriteria Private Sub MetroID_NotInList(NewData...

I agree, looking at the code again towards the end is attempting to open a form called "Markets" (strDocName = "Markets") which from post #1 should...

As you have Markets all over the place, if it has been working before, then I would have to say there was a table called Markets?

Your variables are not fully qualified, please try this: Private Sub MetroID_NotInList(NewData As String, Response As Integer) ' Get confirmation...

Your description is somehow lacking clarity but usually to address the variable\growing number of columns associated with a crosstab query you need...

Same problem is also occurring with the States field, and that has never been changed. Thanks again to anyone who may know how to remedy this.

Now it comes up 'Error 13' Type Mismatch Private Sub MetroID_NotInList(NewData As String, Response As Integer) ' Get confirmation of...

From what you describe I think the issue is related to your combo; it looks like you use the combo to search for the company in the main form then...

Replace it with tblMetro and see what happens: Set dbsSmr = CurrentDb() '> Set rstMarkets = dbsSmr.OpenRecordset("Markets") Set rstMarkets =...

That's what I thought, and indeed looked to see if for whatever reason I had renamed something to "Markets". Cannot find a table or query - or...

If you don't have (or ever had) a table or a query called Markets, then that code cannot have worked. In something of a rarity for Access, that...

Ah, I see. I hardly ever use Access Macros TBH, but I do recall I had to do the same for something I had to back up a database a good few years ago....

I thought that the "Run code function name" gave it away as an embedded macro which only runs functions. Could call it as just - Public...

Assumption TBH, but as it happens a fair bit, that would be my first guess. :)

Paul, How do/did you know the OP came from excel? I've seen posters who call any vba code 'macro', but outdoor is new to the forum.

Save and New I can uderstand. Form should be bound, so no Save needed. As mentioned upload you DB or at least the code behine the buttons. Please...

Suggest you provide db for analysis. Follow instructions at bottom of my post.