Search results

Debugging It always printed, unless I REM the lines, I was testin the Emails and it was fine, then stopped working when I finalized the code to run for users, NOW then, the only other debuggin I did was re add the msgbox at the on error, as you may have seen err.description line at the end...

Help, Internally to our Company we issue forms that need filling in by the factory, this form was always done my filling out one at a time every time it was needed and then emailing ppl in the company that needs to know whats going on, so I automated it in Access, through some code I found in...

I will try that, but I dont know how to add it to the WQB, Im not great with SQL yet so. The other thing is, in the sub form the autonumber just goes up, so entry 1 maybe attached to enty 2 in the main table, and entry 2 maybe attached to entry 3 in the main, but entry 3 maybe attached to...

Im Writing a Dbase to Log our Drawing documents as they come from our Customers.. Now Each month there maybe the same part number but a NEW revision, so the part number is on a form, and the Revision is on a sub form linked so there can be more than one attached to one part number, thats the...

You could program in identifier in Visual basic code, so... checkbox_onclick if checkbox = true then change a field Value to 1 if checkbox = false then change a field value to 0 end sub Im not sure if you can use field that are invisable however, so you may have to put the field off the...

The Reason there is 2 sub forms Bound to the same table, is because I need to have the options to have the same item twice, but also maybe different items in there place, they are caps on the end of hose, so there may be Cap1 and on the other end Cap2 but another part may use cap1 and on the...

when you have the values on a combobox, if the user wants to add another value that isnt there already, is there a way I can have them just type it into the combobox and save it in the list ?

Ive got a form, that has inputs to a table, and it also has 2 subforms that link to another table, the subforms are different forms but they link to the same table, this is bacause I need to be able to enter two different items off the table that may be different items, the reason Ive used...

I like the idea of using the query bulider, Thanks, I will try it as soon as I get in work :-)

EEk! Eek! Query, I will look into making a query to do it, to do it I guess the query needs to be in SQL and when the first field is item1 the sql looks up the weight field to be item 1's weight

OK, so now in my Dbase Ive got the main data, and another table with 2 fields in, in the second table its a part number and a weight, on the main data I need the user to select the Part number with a combobox that the weight is filled in the maindata automatically, I dont understand Relational...

Major thanks Thanks PAT thats Fantastic,

I guess using AccessRT doesnt allow for the Shift key to be used as a backdoor code, I guess because I never used it, all the PC's I program for in mycompany use full office licensed to about 35 computers so everyone uses access full not just the RT. SO.. Im finding some users now know how to...

Does anyone Know how to stop the mouse wheel from scrolling through the records, my Dbase is for non-computer expert users and the ability to move records to the EOF and see a blank freaks them out, does anyone know how to stop it from working, ??? Same for the Print screen, in normal MS...

In my Data base there is a form for entering various data, 3 of them, are one after another, I understand how to make the fields TAB in order, but what I want to know is, is there way of limiting the field so it only allows 2 numerical values i.e 12, or 01, then on the second keypress, it...