Search results

hmmm sorry bout that...don't think I am putting this together clearly. I am not "really" trying to code the whole procedure. Most of what I need is already hard wired into access. The end user won't get into the form in design view (just me). I have a login form that sets my global...

thanks I am actually creating a query that will be used as a filter I have already set the global variable with a logon form Basically I have the query opened in design view and want to use my globalvariable as the criteria I tried to use the SQL code builder, but couldn't get the sytax...

Can someone help me out with using a variable in a sql query I want the global variable to be the condition SELECT tblMain.autonumber, tblMain.CaseNumber, tblMain.Handler, tblMain.[K-9], tblMain.Date FROM tblMain, tblDefaultValues WHERE (((tblMain.Handler)=[tblDefaultValues].[Officer])); is...

Is there a quick EASY way to link tables to the current application directory... I have a database that is linked to tables in another directory. Coding is easy in access if the tables (linked tables) are in a permanent, static directory...in fact, you can even use the table linking tool to do...

Thank you very much. That helps a great deal.

Is it possible to do "complicated" if then else calculations in a query? That would probably be the easiest for me to do. Not too familiar with creating new recordsets in access Thanks for the help. -Pete

I have been pondering this for a long time and still have no idea where to go. I have an access database that performs several calculations when I print the report (happens during the detail format event). These calculations are relatively complex and happen through a series of if/then/else...

son of a gun Here is the error message i get Error: Compile error User Defined type not defined I put this statement in a standard module Public newfrm1 As New frmForm1 I then have a command button on a separate form that has attempts to open the new instance....don't know how to go from...

Need Some Help on this one I have a form that I want to have open, because the user needs to work with it. However, is it possible for me to have 6 different instances of the same form displaying 6 separate records from the same table. I think vb.net handles this by default, but how do you do...

I have a form that I have placed a tab control onto. This (and everyone other project I have worked on) is causing me problems with the tab index on the tab control. I can't seem to renumber the tab control to make it work in a logical order on the tab control. I understand that each page of...

Didn't work Doesn't work in XP. The minute I change the vertical property of the label to YES, the text completely disappears. I can't quite explain that. If I resize it or shape it for a more vertical appearance, no difference. Kind of a pain. I am running XP pro on desktop and XP home on...

Is there a way that you can specify where the cursor will be put inside of a text box. I have a procedure that sets focus to a text box when it DoCmd.runCommand acCmdRefresh and it highlights all data when it sets focus. Is there a way that I can specify in code that I want the cursor to then...

Does anyone else have the problem that when you set a lable on a form to vertical, the text disappears. I guess its still there, but you cant see it, even if you change the back and forecolor? Is this a known error? Thanks

Rich, you were right on the money with this one. Detal_format did the trick. It now calculates for each and every record. Woo hoo. Thanks again for the help. This world forum is one hell of a resource. Wow.

I've done the calculations on the report. it even calculates correctly. However, it only calculates the first record and then repeats those answers in all the following records. it doesn't separately calculate all records...let me see if I can illustrate this better RECORD1------- textbox1=5...

My only problem is that my calculations are quite complex and have nested if statements. I can write out the formulas in VBA. If I use the query, how do I write out the formula?? SQL?, and I dont' know how to use the expression builder with if statements, if its possible. Any ideas??

Just had this problem myself. Go to print setup, set the number of columns that you want, and then where it says column size, uncheck same as detail. Then you adjust the column size to fit how many records you want on the page. Just make sure that on your form, you only have controls in the...

I have a report that I want to print that lists 4 records per page. I have an unbound text box (that of course repeats for every record = 4 per page) that I want to have a calculated value from several of the records. Here is the dilema. It is easy to have a calculated control where...

I'm just wondering if a subreport might be more what I'm looking for. question is, can you have a subreport list only 4 records on one page of a report, and then display the next 4 records on the next page. I've had subreports cause me problems because it put all related records onto the first...

That Microsoft Support Page provided exactly what I needed. However, one more question with regards to that. I want to print one more column, preferably at the beginning of the 4 columns (to the far left) that won't be repeated each time the record is displayed (it serves as a quick data...