Search results for query: *

Hi Everyone, Got a bit of a problem and I have been racking my brains out over it! Essentially the problem is this: I want to be able to create validation drop-down boxes dynamically, say for instance, when a commandbutton is pressed. Code is: With Range("E2").Validation .Add...

Hi everyone, This is a related question to one I proposed last week. This time, I need to ask if anyone knows of a suitable container/control which will allow me to save both text and graphics. I know that a Rich Text Format control will do it, but that saves it in RTF format, which, with...

Here's an interesting question. I have set up a date field (ordinary, bog standard date) and used the format dd/mm/yy to store it. Here is the problem. A normal date, say 12 January, 2004, would be entered as such 12/12/04 - fair enough. However, lets say when the user is typing in the...

Hi everyone, Here is a question that I want to throw out to people, as currently, I don't have a clue as to how to do about it. Ok, basically what I want to be able to do is to have a database that I can store problems, and there possible solutions - sounds simple enough - I have even...

Hi, I am trying to use one of the code samples for the above shell function. It works fine...almost. I kind of understand how to use the flags to create certain things, such as the BIF_NEWDIALOGSTYLE flag for a "Make Folder" button. However, I want to use two flags "BIF_NEWDIALOGSTYLE +...

Hi, I am trying to use one of the code samples for the above shell function. It works fine...almost. I kind of understand how to use the flags to create certain things, such as the BIF_NEWDIALOGSTYLE flag for a "Make Folder" button. However, I want to use two flags "BIF_NEWDIALOGSTYLE +...

Hi, I don't really know how to ask this question properly, but here goes. My problem is this - I want to have multiple users on a database, and I want them to have access to the same forms so that they can enter the data simultaneously. An auto ID has already been created, using the default...

Hi, I have a main form with a contact log subform in datasheet view (the subform is in datasheet view!). I have set the mechanism up correctly so that new logs can be added, and then displaying the last record, but that isn't my problem. My problem is that I want to be able to output the...

Hi, I have a main form with a contact log subform in datasheet view (the subform is in datasheet view!). I have set the mechanism up correctly so that new logs can be added, and then displaying the last record, but that isn't my problem. My problem is that I want to be able to output the...

Hi everyone, I'm considering creating a document library, which will be published onto a webpage, with links leading to where all the documents are stored on a shared Network Drive. I haven't quite decided whether to use Access or SQL for the databases index (it doesn't really matter, as I...

Ok, first the basic part - I have a couple of comboboxes, the second is dependent on the output of the first - simple enough. I then want to be able to disable the second combobox until text is entered into the first (being typed). This is normally done through the afterupdate event, or if you...

Does anyone have a clue how to set the icon of a form in Access 2000 using VB, and also setting the icon as an embedded OLE image (I want to try and have just one file for deployment). I have found the code for setting a file as the icon of a form, but was wondering if it were possible to use...

Does anyone know how to do a date search (single date and range) when the format of the date is dd/mm/yyyy (UK date format). Whenever I enclose the date in #, the date is converted to US style, and so does not correctly filter the form. Thanks

Hi everyone, I was wondering if someone can offer advice on creating an ID code. The idea I want is to have a code along the lines of (for example) THCS1234. Basically, this can be broken down into 3 parts - the first 2 letters are in relation to the results of one combobox, and the second 2...

I need help big time with this problem. I have a database with about 26 fields on one form, and 25 of these fields need to add up and equal the other field. These fields all have double data types so I can use a decimal. I am only going to 2 decimal places, but the error is this: I add the...

Hi, my question is quite straightforward really. I am trying to think of a way of importing data into a database, and then generating a list of error records, if there are any. However, I don't want any records appended (at all) if there are any error records. Is there a way of 'cloning'...

Hi everyone, I was wondering if anyone could help me with making what I want to do more efficient. I need to be able to export 5 tables to 1 Excel workbook. The catch is that the tables are all linked on a one-to-one basis with a MainTable. All the tables have an ID field, which is the...

Does anyone know how to make these tables updateable? I need to be able to use an update query on the msysqueries table. Thanks, Nick

Hi, can anyone please tell me the code to create 3 random letters, I can do numbers but I'm not sure about letters. Thanks, Nick

Hi, I am trying to import excel worksheets from one excel workbook. What I need to do is import one of the workbooks into a separate table, then I need to use the ID field in that table to delete all records in another table that is already in the database with a matching ID field. I can do...