Search results

I have a form which, among other controls, has a multi-line text box, TB_Conditions. I generate a report based on the data of that form and in that report I have a sub-report, rptConditions, that displays the data of TB_Conditions which is placed in the Page Footer of the main report. In the...

That did the trick. Thanks a lot:D

You are exactly right on that What I'd like to do is exactly the opposite of this, store the number as negative but format it as positive. I know I can use custom formatting for that but I don't know if this will affect the data in the table since it's a bound datasheet form

The scanner is passing the barcode read as text? Have you tried creating a new form with just a text box and scan to see if you can get the value there?

I have a subform displayed in Datasheet form and I would like to store in a field negative integers. But, for UI and usability purposes, I don't want the user to have to write the "-" for the negative value to be stored. is it possible that the user will write the number i.e. 1 and in the table...

I have a subform inside a form and in this subform I have an Ordering field which orders the items in the form based on this field. In the After Update event of this box I use Me.Requery so that you can actually see the change of the order in the items. The problem is that after requering the...

I have a form bound to a table, with a subform in there, and I have a textbox with a source one of the table's fields. I would like the value of this textbox to be calculated based on the values of some boxes in the subform, but I also wont to be able to edit the value on the textbox myself. Is...

Thanks a lot man, that did the trick :D I couldn't get my head around it :banghead: I think I'm in desperate need of vacations:p

Hi everyone, I have a form, and in that forn a subform with a list of products. This is the Recordsource of the subform: SELECT DISTINCT ProductSubCategory.ProductCategoryID, Product.ProductSubCategoryID AS SubID, Product.ProductID, Product.ProductCode, Product.Description, Product.VATRate...

Thanks a lot Pat, that did the trick :D

Hi jdraw, my situation is this. One product can be stored in only one place so you'd have a value in "StoragePlaceID1" and null in "StoragePlaceID2". One product can be stored in only 2 different places so you'd have a value in "StoragePlaceID1" and a value in "StoragePlaceID2". You can also...

Hello everyone, I have a table "Product" and in this table I have two fields "StoragePlaceID1" and "StoragePlaceID2". Both these fields link to the look-up table "StoragePlace" *Attached Image "Product_StoragePlace" from the Access Relationship Window"* When I want to add a new Product from my...

Thank you all for you time, I'll post 2 screenshots and I hope it'll help clear what the interface is like and what I'm trying to do. The "Products" is where I can see a list of my Products. As I said it's a form with a sub-form in it. That sub-form gives me the list of my products. I select an...

Hi bob, the reason is that it's more user friendly to select the item you want from the list of products, and with a single button click to add that product in the Sales form

Hello everyone, I have two tables "Products" and "Sales". I have a Main form with a sub-form in it that displays all of my Products in the "Products" table which is in datasheet form. I want to create another form for my "Sales" table in which I will add items from the "Products" table. I want...

mdlueck thnaks a lot for the links, I'l take a look at them :) gemma-the-husky, the reason I'm using arrays is because the arrays that'll be generated I always going to be like 10, or maybe 20 rows high (@ worst). If it would have been a large amount of data of course I'd use a different...

Anyone out there that could give me an example on a simple 2D array? You have an array and you want to move the position of the items(but not from the start of the array-but i don't think this is a problem) on one of the columns to the next position, and of course the last item will be gone...

Thank you for your reply Galaxiom, could you plz give me a small example? For some reason I can't wrap my head around it to make it work properly:oThis is what I've tried For tmpCounter = x To (arrRows - 1) tmpVar = searchArr(tmpCounter, 1) tmpVar2 = searchArr((tmpCounter + 1), 1) If...

Hi Galaxiom, well I chose to go with the array because it's small,fast and easy, and I just use it to populate a temp table. I'm not sure that I'll be able to explain completely and in an understandable way, at least in english :( , how I'm using this array, but trust me it's the simplest way to...

Hello all, I have a 2D array, 1st column holds dates and the 2nd one holds ones and zeros. The 1st column is the duration of the stay of someone in a hotel and the 2nd column determines if at the given date that person's room need to be cleaned(1) or not(0). Now, if the day that the room is...