Search results

Hi, I have to fill out long word forms regularly and I made a macro to check all checkboxes in a column in a table (see code below). It works fine except when a cell has more than one checkbox, then only the first checkbox in a cell gets checked. The problem in my code is that when I update a...

Hi, Does anyone know if it is possible to temporarily disable a constraint in access? I know that t-sql does not support "DEFERRABLE INITIALLY DEFERRED" but is there a workaround? (short of removing a constraint and then creating it again afterwrds, I wouldn't like to do that for every...

Hi, I have the following table CREATE TABLE tbAnswers (answer_id INTEGER NOT NULL PRIMARY KEY, answer_correct BINARY NOT NULL, answer_position INTEGER NOT NULL, answer_text VARCHAR(150) NOT NULL, item_id INTEGER NOT NULL REFERENCES tbItems(item_id) ON UPDATE CASCADE ON DELETE CASCADE...

Hi, I want to automatically log in to a website to get some information of it to load into my database. Below is an attempt to set the value of two textboxes on a login page. Does any body know why this would give the error: "91: objectvariable or with blockvariable not set"? thanks...

Hi, I have an excel sheet embedded as an unbound object fram in a form. I'd like to know of a way to refrence cells in this sheet using vba code. something like me.control_name.range("A1").value was my intuitive guess but that doesn't work (object doesn't support this property or...

Hi, I'm nearly finished with my first acces project (very grateful for all the help I received here by the way). I have split my database into a user interface (only forms and modules) and the real database (only tables) to allow for multiple users and easier maintenance. It works great but...

Hi, I'm trying to create a new calendar folder in outlook (from access) but I keep getting a "cannot create the folder" error message. This is my code below: Set appOutlook = getobject(, "outlook.application") set nms = appOutlook.getnamespace("MAPI") set fldCalendar =...

Hi, I have a (rich text) textbox on one of my forms. I'd like the user to be able to use the enter key to go to a new line. As I found out the enter key does not normally behave that way in a textbox I am trying to solve this through vba code. I came as far as the following: Private Sub...

Hi, I can't get a label or textbox to appear on top of a listbox. I've tried send to back and bring to front but this doesn't work. Is the listbox always on top for some reason? And if so, is there a way to get around that? tnx! kind regards, Jesse

Hi, I have a dragable label on one of my forms. However, when I drag it over a listbox it always disappears behind it. It makes no difference if I send the listbox to the back or bring the label to the front in design view. Is there a way to get the label in front of the listbox through vba...

Hi, In javascript you can sort an array with "array.sort(sortfunc)" where sortfunc is a function which compares two items that you can design yourself. This has always been tremendously useful for me. Is there a comparable way to sort dictionaries or arrays in VBA? tnx Jesse

Hi, I have the following query. It doesn't work and I have absolutely no idea why. Doe anyone know what's wrong with it? Any help would be appreciated. INSERT INTO Reserves (cyclus, Language, First, Second, Third, T1) VALUES (152, "Dui", "SC0001", "SC0034", "SC0135", "slform0001.xls")...

Hi, I've used the following code I found in a book to run sql select queries. This works fine. However, I'd aslo like to do update and insert statements, which this code won't do. I've tried adjusting it in a number of ways, but, so far, unsuccesfully. If anyone could tell me how to adjust...

Hi, I want to get a filelist from a specific directory (in order to import the files later on). I pulled some code of the internet and adjusted it a bit but I can't get it to work. I've pasted the code below. For some reason the part of the code inside the "With Application.FileSearch - end...

Hi, I'm new to vba. My background is php, sql and javascript and vba sometimes perplexes me, so i'm sorry if my question seems stupid. I want to use associative arrays in my code. The way to do this seems to be to use the collection object. I have created a collection (of mostly strings and...