Search results

Hello, I have always been fine taking existing code and adapting it, but not at writing my own from scratch :( I have a report (rpt_MSR_Detail_byAdvisor) that I want to open from a form (called ReportCentral) and on that form I have 2 combo boxes (DistrictPicker & AdvisorPicker). I would like...

Dave, After re-reading your post and digesting it completely, I now get the bigger picture...thank you, thank you. I really don't give error handling too much consideration, but this is something to consider and implement.

Thank you Dave!

I got it working by using "OnLoad" on the other form which in the end may be the better way to do it??? But the cancel is originally what I was looking for (and will put away in my toolbox :)), I just didn't know how to go about it. Thanks guys!!!!!

That is a hidden form that contains the users profile so I can direct them to where I want them to go. But might be able to use that, I'll give it a go.

There is no form that opens this one. This form loads as the startup form (through autoexec actually).

As my main form loads (onload), I would like it to check for users (have that solved) and if thee user is #1 level keep loading the current form (frmMSEntry). If the user lever is anything else but #1, I want it to load another form (frmReportCentral) using VBA. I have it for the most part and...

This sounds like something I want to do for my current project, but did not understand ANY of it. I too have a form with a couple subforms and I would like to duplicate the entire chosen form and subform contents into a new record. And in some cases I would want to duplicate one record many...

Thanks guys! I was thinking I could go into the SQL and just change the table reference to the query of my choice, you just confirmed it. Thanks!

When I combine my to two tables in a query, it appears to be updateable. It's just that in the QBE where you choose your query type and it ask you to choose an append table, the choice is only a table and doesn't offer queries?

I just got through getting an answer on that one... http://www.access-programmers.co.uk/forums/showthread.php?t=175777

Not sure if my approach is right, but here goes... I haev to tables: 1. tblMSR (PK is MSRID (autonumber)) 2. tblPrntReq (FK is FKMSRID) (tblPrntReq is sub of tblMSR) I want to automatically add records in bulk to these two tables. So the first thing I want to do is add one record to the tblMSR...

Worked perfect! I couldn't find much on google about the A_Form is it possible for you to explain? Again thank you very much.

Wierd, I didn't realize that the VBA was a "filter", but tried to "remove filter" on the record while I was in it and it didn't do anything. :confused: Anyhow, what yo say makes sence and I will give it a go soon and get back to you. Thank you very much for your help!

taking our time...

Hello, The code below opens "frmMSREntry" to a matching "MSRID" field from "frmsearchcentral" and closes "frmsearchcentral". Seems simple enough, but once I'm in the desired MSRID and want to move to the next record I get an error saying I can not move to the specified record. So I am stuck in...

I just got through doing a heart felt thank you in another area and then ran across this. I too am very thankful for all the help we get here. Oh, and I'm working on a school assignment and need a working design in 20 minutes...LET'S MAKE IT HAPPEN GUYS!!!!!....jk,jk...I always get such a kick...

To all that contribute & manage this forum...THANK YOU. As we all are suffering during these tough economic times, I am very thankful to have my job. I began to think about what makes me different than employee "B", as we all should do, and quite honestly I would say it is my Access skills...

That did it! Thank you very much.

Hello, I know I've done this before but can't seem to remember exactly how. I have a combo box called "PrintDevice" and the values for it com from a table called "tblPrintDevice", that table has a 3 fields (PDID, PrintDevice and PrintCostFactor). The row source for the combo box contains all...