Search results

Thanks for the reply. I ended up re-designing the form, placing the OLE objects outside the Tab Control. But is is really strange, as even the "Automatic Update Function" (e.g. ".UpdateOptions = acOLEUpdateAutomatic") does not work on a Tab Control... Maybe a bug?

Hi all, I've a weird problem; On a Tab Control inside a from, I've created an Unbound Object Frame, referring to an MS Excel Work Sheet. The goal here is to link that Unbound Object Frame residing on the Tab Control and save the form/link. Now, when I execute the code, the Object Frame is...

Any luck regarding the solution for this scenario? I may have the answer...

Hey PST, Could you please be more clear... I really don't understand what you want.. So you have 1 combo-box, containing the primary key, fill is the list boxes on your form. Now what do you mean by you are trying to keep record 1 and move to record 2? Could you make a snapshot of your form...

Hey again, tnx, I think i found it, but the code behind the list box is just too complex for me to understand on short notice. I think I will stick with my own. However, I found something about how to determine the ratio as acurate as possible. I will give it a try... Tnx again. :cool:

Tnx RuralGuy, What they have made on that site is not for a listbox, it's for a table/query viewed as Datasheet. Anywayz, I made the function myself. (see below) The only thing is to find a good length to cm (or inch) ratio (colRatio) in order to set the columns to fit as best as possible for...

hello all, I was wondering whether there is an "easy" way to make the column widths of a list box to adjust to the largest peice of data under it.... without filling it in yourself in the design view... So in VB.... I know that there is the property COLUMNWIDTHS, and that you can adjust it by...

Btw, mresann ==> I'm trying to add a new record. But updating will become part of the form as well... but first I need to fix this issue of 12:00:00 AM emptyr dates!

Let's investigate Dear Rich and everybody else, tnx for the reply. I will try a different approach to tackle this issue, and maybe you can find me get over my stupidity! I made the following function with the things that you guys say should happen, and what actually happens on my VB...

Than you all. mresann ==> I tried your way, still no luck. I put this into my SQL statement. May it is different when you are trying to insert a date from a FORM field into the table through the DoCmd.RunSQL. Maybe you can help me if I explain it better. The date which is selected from a...

thank you for the reply. mresann ==> if statement should do the trick. But I have 4 date field. Of which 3 are not obligatory. So I would have to make 7 of if statements with different SQL statements. Or I could conjucate the value section of my SQL statement with a fucntion. But I don't get...

Dear All, I'm trying something quite simple, adding dates into a table with the aid of an action SQL statement (INsert Into) in VBA. However, if a date is empty, the value 12:00:00 AM is filled in! I really want that if it a date is set to empty, that noting is added to the table... I can...

Hey again, It is quite simple to solve. You will need to make different buttons; 1. For new entry ==> For this button, you can use Dlookup function. The dlookup function crtieria will be based on the Values of the product attributes selected by the user. You can either use different controls...

IanWright, Your Idea is possible, as I am busy more or less the same thing. You can put the IDs in the table, based on what they select. You will have to write VB code for it. If the attributes of the products are unique for each ID (which they are I assume), you can use "DlookUP" function...

Dear All, I'm trying to link to Oracle through ODBC...everyhting is set up, and I can connect and I can also see the tables..The problem is...there are just toooo many tables in the link window!!!.... Does anybody know how to find the right table you want faster??? Or how to limit the tables...