Search results

1. How do I make this invisble Let's say you have a form named ReferenceForm. And on that form you have text boxes that get filled the same way as you filled form MAIN. to open and hide the form... use... DoCmd.OpenForm ("ReferenceForm"), acNormal, , , , acHidden 2. Do I use the same process...

>>Ok I can see the name on the Menu form and also the quote screen, but I dont understand where it is getting the data into it from, please explain. --go to design view on the login form. check the button OK OnClick Event. this sends it to the main form. When you go to the Quote Form, the...

Colkas, Please view the updated .mdb. I am not going to do ALL the work for you :) I did the first one to show you how it works and you should be able to follow that to complete the rest. >>In the FormQuote I would like to see the login Fullname and Position on the screen -- I simply showed...

Altin, if you want to put the table ( or tables ) into a db and attach it, along with an example of your desired result set (posted here), I'd be happy to take a look at it for you. ..bob

by this... if you mean that the user is being prompted if they want to insert the data or update data... and you want to avoid these prompts.... then (in versions prior to 2007 you can set warnings on and off as a step in the macro) I just checked my 2007 and did not see it.... so... you can...

Ricky, Not sure what you mean by "using subform to link that query" but.... you can set the OrderBy property in the vba. be sure to set OrderByOn = true. so... after you change or requery the data in the subform... add Forms![YourMainForm]![YourSubForm].form.OrderBy = "YourCol1, YourCol2...

In SQL you could use a ranking function in a CTE. (If your app is an adp I'd explore that). If it's an .mdb or .accdb, I'm sure there are other ways but.. I would probably create a temp table with the columns you need + an auto-incrementing ID for the PK. then you can write a routine that...

Hi colkas. The easiest way I can explain it is to simply create a text box on your report. Then, in the control source for that text box, simply point at whatever you want to be displayed in that text box. An example I can give is .. I have an application that has a report where I want to...

>>, or I am happy to supply the DB, there is no important data in yet. Please send the db. thanks, ..bob

How about this... Assuming your main form has a textbox: txt_UserName Add textbox control to form you are opening the report from. txt_CurrentUserName In the OnClick event of the button that is verifying the credentials... ..if verified, DoCmd.OpenForm ("YourForm_MainMenu"), acNormal...

Glad to help Vae.

Not sure of what else is going on in your code but... I have no idea what you mean by "choosing end". try shifting focus as needed. ( including after doing the find ) hth, ..bob

Galaxiom, >>That is not valid SQL. I think this is what Bob was aiming for: -- What I was aiming for was union .. ( distinct ) as opposed to union all which shows everything including dupes. I should have used [Name] with brackets though. Thanks. And again.. I forget that aliasing...

would something like this work... in the OnCurrent event of sub form Data1.. dim id_d1 as long id_d1 = me.fileID Forms![YourMainForm].SubFormData2.form.SetFocus DoCmd.FindRecord id_d1 hth, ..bob

Vae, your error was due to me using... AdmissionIdCnt = ( as opposed to AdmissionIdCnt: ) I write all my queries in SQL and forget about Access Aliasing names with a colon. Let's try again. Does this get you there? Select AdmissionId, AdmissionIdCnt: sum(iif([Answer] = "Yes",1,0)) From...

have to ask.... is there a PK in the table you are trying to Insert into or update?

>>Name Q1 Q2 Q3 Q4 Q5 This is how it needs to look: Name QuestionID Answer How about Select Name, QuestionID = q1 from YourTable union Select Name, QuestionID = q2 from YourTable union Select Name, QuestionID = q3 from YourTable union Select Name, QuestionID = q5 from YourTable union...

>>I have to count the total [yes]'s that appear for each different [admission_id] (not sure what your PK is but assume ID) How about.... Select Id , AdmissionIdCnt = sum(iif([admission_id] = "Yes",1,0)) From YourTable Group by ID

How about something like... After copying your table to a backup table.... Try opening a new query and pasting this into your sql view. UPDATE [Trip Registration] SET [Trip Registration].[Trip1 Confirm] = IIF([Trip Registration].[Trip1 Coord]=True,"C",""), [Trip Registration].[Trip2 Confirm]...