Search results

So your main Access database has a file dialog where you can select the external Excel/Access file to import? Also I think my situation is different from yours because I want to use the Excel files because Excel has faster calculation capabilities. It involves changing the costs of various...

Well where do you put the VBA code for the import and export, in the Access or template file? And what do you mean by terminal server?

I want to use Excel documents for data entry for each of my projects in Access. After the data has been transferred from Excel to Access, I want the Excel doc with the entered data to be saved in a folder for that project with other relevant documents. The Excel data entry doc is a template...

I am using what you call a multiselect combo box. The multiselect combo box allows me to select multiple items simultaneously, which are stored in a multivalue field in a table. Yes, multiple items, each separated by a semicolon, saved in the same field, based on a list of possible values...

CJ London I thought you were making a differentiation between combo boxes and listboxes. I don't understand what limitation you are referring to, or whether you answered my question. arnelgp that just returns the list of possible options. I am talking about retrieving the currently selected...

No answer for this? Do I have to write complicated VBA code just to cycle through and compare the values of both multivalue fields?

No, I am using a combo box with multiselect based on a multivalued table field. The combo box that drops down allows me to place check marks next to multiple values. As I said, the OnChange sub allows me to retrieve the values via ItemsSelected(x) and Count properties as in a listbox, but only...

Wow it worked. Thanks! So "Is Nothing" can be used with any pie in the sky variable name that hasn't been defined anywhere? I wonder if a Tempvars variable can be a Collection? Right now I have a tight schedule and don't want to bother testing it.

I have a global variable of type Collection defined in a module. I know if I get an uncaught error the global variable will no longer be defined. But I am trying to check if it is undefined and if it is then call a function that sets it new and assigns its values. But I can't find a way to...

This is a weird problem. My combo box only has values inside of it's onChange event in VBA. Its ItemsSelected.Count value is 0 in every other function, but correct in the onChange event. Trying to access a value via ItemsSelected(0) produces an error in every function except for the onChange...

I have a table with a multivalue field. I have a search form with a combo box where multiple predefined search items (corresponding to the possible values of the multivalue field) can be selected. I want to filter the query based on the table so that it only shows records whose multivalue...

Yes, but again I don't know how to make it switch back when the user presses escape to undo. Access only automatically switch controls back if they are bound through Access to the underlying table field.

It's not a built in toggle button because I don't want it to look like it's pressed down for one of the options. The button should only change color and text. As for the key events, that still doesn't give me a way to know whether the checkbox was one of the items that was reverted or it...

I have a toggle button that changes its color and caption whenever an option is chosen. I made a checkbox linked to a field to store the value, hid it, and then made the toggle button that checks or unchecks the hidden box in it's onClick event, along with changing the appearance of the button...

I want to give my users the ability to add more options to a listbox (or combo box though I'll use the word listbox in this post). I have run into two problems: 1. The listbox control requires me to enter a form that will be called to edit the contents of the list. I would have liked to just...

Okay I did that but when I change the ForeColor it seems to color in the background, at least in a box slightly smaller than the cell. This is visible because alternating rows are colored slightly darker in Access. Is there anyway to prevent this background box from being filled in? Also is...

A column will have either the word "Offer" or "Order." I want the text to appear as a hyperlink (blue underlined) if another column for that record is not null, otherwise normal black text. I know how to make the entire column a hyperlink, but how do I do it for only certain records?

I have a main form for orders and a subform for items in the order. As I understand it, the subform OnCurrent event fires both when I move through the subform and when I move through the main form to a different order. As we know, subform Load and onCurrent events fire before main form events...

But can't Autonumbers reliably be used to find the latest record added to the table? Since Autonumber does not fill in gaps caused by deleted records, I should always be able to assume that the highest Autonumber is the most recently added, right? Or what happens if I reach the highest...

I have a button on a form that opens a print preview of a table in a form datasheet. The forms will often be opened in full screen mode, which means the print preview will also be opened full screen. The problem is, print preview removes the X button for the form window that normally appears...