Search results

Do you have a form that you use to select the file to be loaded? If you do, I would assume that you use the commondialog control... Could you not use a variable and store the size in a variable at time of selection? MyFileSizeStringVariable = FileLen(Commondialog1.open) & " bytes"

Access is just messin with me now.... If i change the listbox property to "simple" multiselection it works peachy keen! ......AHHHHHH

Ok. On the Plus side, I learned a new way to reference the selected items in a listbox! (big win) On the downside, It's doing the same thing....

Thanks for the reply VBAInet. I am selecting the values in the listbox manually. I'll look into the ItemsSelected Property and report back. (fingers crossed!)

Hello all! I'm running Access 2003, and I have a List box with "extended" multi select enabled. My code: Dim i As Integer DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 With Me.List26 For i = 0 To .ListCount - 1 If .Selected(i) = True...

Just as another option.. if they have a server... with a website couldn't you push out some access datapages and have him access the pages via the Ipad's Safari browser?? At least with that option... you have all the software you need already installed on all machines... (this does assume a...

You need to go into the VBA Editor and Add ComboboxName.Requery I would add the code to the "on change" event of your comboMonth and to the "On Current" event of the form. Which will requery your combo box on every record change. Which forces it too recheck the value of your comboMonth.

Any idea on what else it could be???

Please Refer to this KB http://support.microsoft.com/kb/269370

I am running Windows 7pro. When I go to my Harddrive and select the "windows" folder, i can select properties, I get a folder size of 21.9GB on the disk. Ok fine, If I then go into the folder and select all Items within the windows folder. (ctrl + A) And then select properties, I get a...

No one has mentioned MS Synctoys, which I personally Like as a simple and quick "backup" application. If you have to stop the process at a given time and come back to it later, It wont waste a ton of time trying to overwrite the same files. plus you can choose which way to move files in the...

Thanks guys! it was a combination, I needed to store the DSN file on the server and then link to it from there (intead of being on my local development machine) And then i also needed to add the user group to the SQL login so that they would be granted access to their data. Thanks for the help...

I am new to the SQL databases and have been working on getting a few of our database applications converted to SQL Currently I have a database in which i upsized to SQL from Access. The backend data went over fine, and the front end linked up nicely using the linked manager. However, the front...

Is it possible to make a report off the information displayed on a form... specifically the values displayed in unbound text boxes which have been populated through VBA????

Worked like a charm! thanks!

umm.. sounds easy enough...... :confused:

well done. I'm fresh out.

Ok I was searching online and i'm wondering about a record set. I think either VBA or SOS helped me with these in the past... If i created a recordset would that work? record set and a hidden list box are sorta the same in a way are they not?

The attachment in my first post is how it currently looks. I want to add up the student column.. but where i have... 80 80 80 79 79 79 I want 80+79 (which are the values in the SINGLE parent record) I don't want 80+80+80+79+79... ect.

Nope. It's all one list box. I want to display the tally in a text box at the bottem of my form.. i'm thinking maybe a hidden list box???