Search results for query: *

Hi all, Downloading visual basic 2008 express is a 2 phase download; 1st you download a 2.6MB file that gives you the option to run or save. Then after running it it starts a second almost 200Mb download without the option to save. How do i save the conplete Visual basic 2008 express edition...

Hi, Me.LoneID.BackColor = “then how do i look up the code for the specific color I want” In Access 2003 “16777215” represented the color white but in 2007 “#FFFFFF”. How do I use “#FFFFFF” in my coding? eon5

I have created a form with the following information; Key field1 field2 Records ID: Expense1: Expense2: 001 R20 R25 002 R15 R10 Of course the form is displaying only one record at a time with the values of...

I have created a form with the following information; Key field1 field2 Records ID: Expense1: Expense2: 001 R20 R25 002 R15 R10 Of course the form is displaying only one record at a time with the values of...

Hi, I have the opportunity at work to tackle a very nice system integration project. I can easily set up a very nice, user friendly database with access to integrate most or all of the current disjointed systems. The integration project includes things like; - issuing of job cards - managing...

Hi, I have a cell with the value 00023455/2 in it, then i trim the content from both sides with a macro to the following value 23455 My problem is that one of my vlookups still don't see this as a unique number 23455. Thus the vlookup fails. i can even see that the cell content aligns itself...

Hi I use the following code to act on when the value is smaller or equal to 5% and it works perfectly. If Sheet9.Range("n" & y).Value <= 0.05 Then I need some advice on the code if the macro should act on a number that is between 5% and 10% Thanks

Hi, I need to concatenate some work, but can someone help me to get the code right. Recording the macro does not help me very much. Sheet2.Range("b" & x1).Value = Sheet1.Range("c" & x1).Value CONCATENATE Sheet1.Range("b" & x1).Value Thanks

Hi, i have a command button on sheet one and want to copy info to sheet7 with the following code Windows("StockOnHand01.csv").Activate Sheets("StockOnHand01").Range("A1:AF25000").Select Selection.Copy Windows("Test1.xls").Activate Sheet7.Activate...

Hi, I’m currently busy with a project whereby multiple users are using the front end to manage a simple stock process. I see my textbook talks about a runtime engine so that the other pc’s can use the program without purchasing an access license. This is just what I need. Im using access 2003...

Hi, If i try to split my access database it stops with an error messages " Subscript out of range" and also "invalled procedure call or argument" any idea on what is wrong? Thanks Theuns

Hi, I have do until loops that is deleting cells that contains the code CUSF00110. If sheet2.range("a"&x).value = "CUSF00110" then It works perfectly but more codes starting with "CUS" is getting generated in the data base. Thus the do until loops must delete not only that specific code...

Hi, Im using the following code to lock the information of a subform on loading the main form. Forms!PurchaseOrder!PoSubForm.Locked = True And it’s working perfectly, But when I try to set the focus to one of the text boxes in the Subform with the following code...

Hi, I have n ocxCalender on one of my forms and when i activate it to load the date in a text box...the calender loads the date feb03, this is irritating because i have to select dropdown list 2008, dropdown list June and then the date. Current date will make life for the client easier...

Hi, I have a Macro that is opening a form in Dialog mode, is it possible to have a resizable bottom right corner so to resize the dialog form as the user see fit. Thanks eon5

Hi, Im using the following code to change text format to Capitals. "production plan" "PRODUCTION PLAN" If KeyAscii > 96 And KeyAscii < 123 Then KeyAscii = (KeyAscii And 223) End If End Sub Is there any other way of coding so that it will only change the Firts...

Good day, I have completed a small inventory system for a client with a small business. Currently he does not have access on his computer and I would like to get this thing going, is there any way to run the access 2003 program on a pc without access 2003. I heard something about “Runtime...

Good Day, In my current form “ComponentInformation” I have a procedure called “Refresh” when I click the refresh button on the form it works perfectly. In my second form “VendorInformation” I would like to call the “Refresh” procedure after updating the VendorID. How do I call code that is in...

Good day, In my startup mode i already unselectd the Status bar and the database window for when the client opens the program. Is there any way of coding the load form so that the Menu Bar, "File", "Edit" "View", etc is also inactive? Thanks Theuns Goosen

Good day, I got this code in the search files from “TheIceMan1” and it’s working very good to change All text immediately to Ucase. Private Sub CompCat_KeyPress(KeyAscii As Integer) If KeyAscii > 96 And KeyAscii < 123 Then KeyAscii = (KeyAscii And 223) End If End Sub I’m using this...