Search results

Thank-you very much, this is exactly what i was looking for!!!

is there any way i can put a variable in the path name... i.e. me.imagename.picture = "c:\path\"variable".jpg" the varaiable will be from the combobox, so that i don't have to make a column to store the image path.

GazGump , what is your code to hide the navigation pane?

Solved my own problem....LOL. I set table format as follows... Format>Number Data Size>Decimal Scale>2 Decimal Places>2 Works fine like this :D Sorted, you may lock

Any more thoughts on my formatting problem?

Same here Same thing here, Weekend calls. Will continue monday.:D

yes i want to display the "fixed" format , which is integer + 2 decimals. But when i select any of the number formats, it rounds to the nearest whole number. Everything I've tried does something like this 45.8348738 turns into 46.00 or 46. I want it to be 45.83.

I've tried everything under "Number", it always rounds to the nearest whole number. I'm guessing i have to write some formating VB coding, eh. I store data is for a temp report, I couldn't figure out another way to save calulated values that change with every record entry, other than a temp...

Hi all, I got another queston for you gurus out there. I have a field in a table that populates from a calculated textbox in a table. The data is displayed in the textbox with the "fixed" format, but fills the table with the full value. I want to have the same "fixed" format displayed for...

I'm not explaining my problem clearly..... I need txtD-txtF to auto poupulate with the data from txtDD-txtFF repectively like txtA-txtC does from their respective sources. When I change the controlsource to the txtD-txtF, Anywhere I put the equations in events txtDD-txtFF they do not populate...

Well over the weekend I have figured out a solution. Now the question is can i get it to work. I looked at my form and saw that 3 values are saved and 3 are not. The 3 that are saved are user select/input values which have the control source bound to fields in the table. The 3 values that are...

Hi Everyone, First I'd like to thank everyone for helping with other questions I've had. My stumbling point now is that I want to save some calculated values in a form to the table it is bound to so I can print a report of the data. I know that if I put the equations in the control source...

you can lock it down. btw...stickty that coding.

I was thinking that i was making this more complex than I needed. So basiclly, I need to create the table, then make the form bound to the table with the add record button. This I'll probably start the DB over again(Rev3). LOL, they keep adding more things they want to do as I'm building...

Yes, each set of data will be unique, and will need to be saved as it's own record. But I do not want this data to be stored automaticly after the calculation happens. I want the user to be able to change input values or selections to satisfy their needs. Therfor i will need them to trigger the...

I'll try to explain what i'm wanting to do better. On my form, the user will select data from two combo boxes then input data in two text boxes. A calcuation will happen in the background afterwards displaying the quantity. If the data is what the user wants, i want them to click a button to...

THANKS!!!!! That was the ticket. It still amazes me that they dont have basic functions for something like that. Now on to the next problem. 8-/

Lunch is a good thing. :) I'm sorting the row source type in a quary for a combo box. But the only options I have for sorting are ascending and descending. I'm very new to Access and databases.

I'm sure this has been asked several hundred times, but how do I get items to sort like this : uw-10, uw-100, uw-200, uw-1000, instead of the typical uw-10, uw-100, uw-1000, uw-200 order. i imagin it has something to do with sorting by character count first then alphanumeric value.

Hi All, I'm new to database construction and have a question about the "Add Record" button. How can I make this button add selected data from a form to a table. I have already built the form, but i need to print a record of the data it calculates. Do I add code to the macron of the button...