Search results

Get a badge engraved that says "Actually, I don't work here"? Yes, please, do this. And a video would be great!

Ok The_Doc_Man, That seems to make sense to me. I can achieve the outcome I want, but I was hoping of a different way of doing it. And you post I think explained what I was looking for. I don't think what I was hoping for is possible, but I figured I'd take a hack at it. And thank you all for...

I understand, I didn't take it as being critical. And you have helped me out with many a problem. And I appreciate your help very much :)

It probably is, but I used it just as a generic "this is the input" variable. But thank you for pointing that out. I should have mentioned that.

You should be able to create a variable that concatenates a string containing the * and the text box input Dim Input As String Input = * & [txtRefSeach]

I'm glad you worked it out :) I my self have spent many hours working on many of my own issues. Many many errors... haha

So... You want 2 fields, with field2 relating to field1, and have it look like this? ------Table---------- --Field1---Field2----- --100* ---4500*----- --------------------- But the problem is you have it all imported into on field looking like this? ------Table----------...

I would suggest adding code in the AfterUpdate or OnDirty Events. Use some code like... Private Sub Subform_AfterUpdate() Dim PathForLater As String PathForLater = TextBox End Sub Then you have a string variable in the VBA Code to pass along. And if they were to Update the [TextBox], it...

hhmm... sorry if this is hard to understand what i am trying to say, it is also hard to figure out how to say... lol I have variables to represent ranges, e.g. [ProvostSch_1] is the first GPA range for the ProvostSch Scholarship students. [PresNewSch_1] is the first GPA range for the...

I understand the array now, and I like that idea, but I forgot to mention that I need to fill an Access Form with this. Ya, I'm hoping this example will help (I was actually typing it up as you responded) This is what I need to fill ------------Scholarship #1------------------- - GPA...

Um... I need to variablize a variable name... if that makes sense. e.g. use the variable [var] to equal [var1], then [var2], then [var3], etc. but I dont want to hard code the 1,2,3,etc. part I am hoping I can use a counter variable to define which variable to use. when [counter] = 1 then...

I'm wondering if it is possible to set a Variable as a Variable. For example... A set of variables all starting with the same name that are appended with numbers. such as Var1, Var2, Var3, etc. I want to run a loop that goes through this list of variables by using a count, so that I do not...

ah, DLookup. thank you :) This forum has always helped out, you guys are great!!

Code: ScanID = Right(ScanID, 9) ScanID = Left(ScanID, 6) DoCmd.OpenQuery "ScanIDtoBoxNumber" DoCmd.OpenForm "Boxes" [Forms]![Boxes]![Boxes_Box Number] = ____________ I need "[Forms]![Boxes]![Boxes_Box Number]" to be assigned the value from a query. The query name is...

ok, so i just copied the excel data to a new blank excel sheet and it works now. My only guess is that access thought that there was something that I wasnt seeing, like off to the right. Thanks though. If it ever happens again, I like you idea.

I just hit a large bump in the road... I tried to import an Excel file (which I have done before with ease), but this time Im getting an Error. I believe that I formatted the Excel file properly to match the Access Table, but it brings up an error: Subscript out of range. (And I hope my...

Ah, that makes sense, thanks for the coding part :)

Ok, so my database is set up to print a report that is a contract from a customer in the database. I used to just print the report, but i would like to export them to MS Word and save them. I know how to export them, but it does not export the whole report, just the data part. Any ideas? Also...

Ah, good idea, ill try that, thanks

When I print a report, there is a extra blank page that follows. Any ideas on how to fix it? Or at least tell it how to only print the first page? I tried making the report shorter and less wide, thinking that it was just overflow of nothing onto another page, but I don't think that is it.