Search results

Thanks Pat I found this in another thread this morning. I.e. If you are also running, say, WinZip at the moment, Access can't see that without calling a module from the Win32 API library. The good news is, Access can call functions from the API .DLL files. So if you do make such a call, you...

you got my gist. There is nothing wrong with a dbl pk. I just agree you should have used a fk for the code. Then this would all be clearer...

np Thanks for replying, I may not have explained myself well, and you allowed for me to point out exactly what I need if possible. I have found a way to call a vb .exe as a message to tell them they have a new order, from the access db when they get new orders... lol But I was hoping for a...

From what i see... Your primary key in both tables are the same... Or their names of the fields are. "The Variance table is the main table. I've got a multi primary key with Proj# and Var#. I've put the Code of Accounts in a different table because, for every variance record there can be...

well I tried modal = true . does less then app funtion I been tinkering with. What I want to happen here... Is my application will be running in the background... while they are working in excel / AP program / outlook ... I want my application to come to the front on the window on their PC...

Thought I may have it... but alas no... I tried a msgbox after set focus to the frmOrders... but it still remained in the background just flashing me.. My biggest concern with it just flashing, is that a user not be at their pc when it does... and my boss wants it at the fore front...

Ok, problem at hand. My boss wants my application to come to the front after the reception enters info pertaining to an order. Interaction.AppActivate "frmMainOrders" This sets focus and causes the application to flash on the bottom of the screen. But does not move this application to the...

good points... I was just reading between the lines on this site having costs. and he footing all the bill and was just trying to offer creative ways to perhaps generate some revenue to help with the overhead. You think I want to pay since it's free... and you are right, sharing a knowledge...

I have... Used these forums alot and they have helped me with various problems and where I could not find a direct answer, I found alternate solutions. The code for functions / procedures / modules for vba have prooved to have great depth and vast amounts of code and for this I am eternally...

common... 2 ways. A - you can link the excel file to access, so formatting is kept. B - simple way, add a small ' before you text ... C - last way, you can run macros in excel to clean files as well...

more. Do you do any dao vb programming.? If so this is easy... If not. then you need to make a query. Are you sure there will never be 21 entries in the same month...? You do these entries...?

. I added this because if you change validation at table level. You still get access entry messages... and my boss hates them....

Sure you can... On your text box.... You goto event. OnChange() dim chk as string chk = txtDecrs1.text if Isnumeric(chk) then else msgbox("Entry must be of numeric values only buddy!", vbokonly,"Bad DATA!") end if You can write nicer messages... :cool: There may be a syntax error, as...

Can't quite read you bro. You may have to better explain, or zip the db and let us see for ourselves... To better follow you, unless someone else understands, this may be why no one replies.

Thanks guys. Zoombox is a nice feature. I noted it and it will be of use, just not in this case, paticularly since I am using a combo box for one of these fields, and this feature takes me away from the control and autofill possibilities of the combo box. Control Tip, well users need to see...

Yes it does. I explained.... rs(0) = table customers field1 rs(1) = table customers field2 rs(2) = table customers field3 rs(3) = table customers field4 rs(4) = table customers field5 rs(5) = table customers field6 so for example if you add another text box. txtWhatever.value = rs(4) would...

well... I am not one to get into subforms.. in subforms, feedings details of of.... But here. Nice clean form that works... rs being you recordset in the event Combo2 Events Afterupdate() "new code" rs... (0) ; (1) ; (2) ... whole table ... can now be assigned to any tect box you bring in...

To speed this up...? Status bar a way to assign the text being entered..?

Is there a way to show a user all the text they are typing into a control. Example.... field 25 length the layout on the form ... when the user is typing into the text box. They only see upto say.... 10 characters ... I can adjust the width on got focus and change it back on lost focus...

actually... me.cmbSkyCondition.RowsourceType = Table/Query me.cmbSkyCondition.Rowsource = SELECT MyTable.MyFields FROM tblMyComp Where MyTable.Date = MyTable.Date - 1;