Search results for query: *

Long story short, I'm fixing a comp for a friend... troubleshooting told me his motherboard needed replacing so we got a new motherboard and on bootup I get the dreaded missing or corrupt HAL.dll. Now after researching this error I found that it is usually a problem with dealing with dual boot...

I need to choose 20 randoms numbers from 1-30 and put them in a string joined by ",". I'm using the code: Dim x, y x = 1 y = "" Do Until x = 31 y = y & Int((30 - 1 + 1) * Rnd + 1) & "," x = x + 1 Loop y = Left(y, Len(y) - 1) 'example result...

Ok, I have a listbox called BLIST (stands for Buildings List). It is set to multi-select and I want for users to be able to choose multiple buildings from this listbox and then click a status button. Either 'Inhabited' or 'Uninhabited'. Then I wanted to apply the new status to the recordset...

(Short Story) I have put code in the Report_Close() Event. It is supposed to open Modal forms I had to close in order for the Report to gain focus once opened (which still doesn't work). Anyway, I can tell this code is being processed multiple times while the report is being opened as if the...

I'm trying to filter a report based on the month of a date. In the table the field [DATEX] is a Medium Date format and on my form the field MONTHOPT is a 2 column value type dropdown box listing the months by name and month value. (January;1;February;2;March;3...etc.,)--Bound Column: 2 for the...

I am making a form to enter User Name information and I'm using some Capitalization code that I got from this site years ago. (quite handy too... kudos to the author... I have no clue who it was - wasn't me though) Anyway, usually I don't have any problem using this code. But that's because...

Dlookup Part Can't figure out what I'm doing wrong, am I using a protected word or something or is it something with an autonumber. IM.Value = DLookup("[IM]", "IMMtbl", "[IMID] = " & SENTLIST.Value) IM.value = textbox on the form (updatable not locked) [IM] Memo field on IMMtbl [IMID]...

I am using Flash on my website so the form is on a flash page... this is not my problem, that works just fine. I call getURL("Team4Reg.php","","POST"); in my Flash page and it calls the right .php file. Which then processes my form just fine, sending the appropriately formatted emails to the...

I've searched for several hours on Tek-Tips and Google to no avail. All I'm looking to do is click a button to open Outlook and go to a particular Calendar view. I can't seem to find out how to do this. All I can find are references to Lebans and some other calendar add-ins. Again, all I...

I'm trying to find the number of records in a table where the TIMEOUT field has yet to be filled in. xck = DCount("[VID]", "VLtbl", "[TIMEOUT] = " & Null) It's not working... and I thought maybe TIMEOUT was a reserved name, but I tried something else and it still didn't work. Am I doing...

Ok, I'm having a problem with this SQL and I think it has to do with the fields that are percents. Should I be using a delimiter here... Please look this over... sorry for the length, I thought it best to show the whole thing. (tn = TableName and the TableName has hypens in it... does that...

I had written a long explanation but decided to rewrite it... here's the skinny. I have a client side database that scans the table for new entries. When it sees one it updates a listbox. The code is placed in the On_Timer event and cycles every second. I want the form to popup on the...

You know when you click in a cell and there is a dashed border around the active cell. Or when you click a column or row and it highlights the column or row. Or when you click in a cell and drag a bunch of cells and it highlights them all. I've lost the ability to do that. Let me rephrase...

On my form I have code that takes data from a table and creates a .ppt based on a template (filling in the data from the table). Right now I have it where a form comes up and there is a button on it. I click the button and it does everything. Then I have to alt-tab to the .ppt and go thru the...

I've searched and searched for an answer so now I'm posting. I'm trying to append a worksheet in a particular workbook and not create a new worksheet in the workbook. Reason I MUST use the old worksheet is because the first 4 lines are structed headers...with comments and autofilters and such...

Just what the subject says. Normally if you use a cmdbutton to Preview a Report... it will work fine if the Form is not Modal. But I have a POPUP Form which is also Modal with a cmdbutton that Previews a Report and the report opens but stays behind the Forms. Is there a simple way to bring it...

I'm running an UPDATE SQL statement and sometimes it works and sometimes it doesn't. I can't figure out why. addbulletsql = "INSERT INTO BULLETtbl " _ & "(SSN,BULLETSTART,BULLET,NOTES) "_ & " VALUES ('"_ & Forms!PERSONNELfrm!SSN.Value & "', '"_ & bulletx & "', '"_ & ADDBULLET.Value & "', '"_...

Ok...3rd post in 2 days...my errors seem to never stop coming. Can anyone see what I've done wrong. I know it's this line of code because if I comment it out...all other parts of the code work fine. Only when I set this line to run will the program screw up. The error I'm getting is...

I'm dealing with 2 forms: #1 - Forms!CHANGEQUERYfrm!CHANGEQUERYSUBfrm #2 - Forms!BGfrm #1 is where the labels are that I want to change the fontcolor for #2 is where the forecolor value is for all my forms in my database. The field with the forecolor value is FONTCOLOR.value Currently I...

Here is what I have. I've got a table with 43 fields that I want to query for a datasheet(for my example code I'll only use 5). I want the user to be able to enter critereon to filter each field if they want to. So on one form I have listed checkboxes for all the fields. If they want the...