I'm not really sure how to do this, but I'm sure there is a relatively simple way for some of you all who know this stuff better than I do. So here is where I'm at and where I'm trying to go. I'm looking for any input on how to get there.
I have two worksheets, called 'Input' and...
I think this is an easy question, but never tried it before and having problems getting it to work so figured I'd pose the question. Any help will be greatly appreciated.
What I'm trying to do is run some code (a select case statement) when a specific cell changes. The code (the select case)...
Finally able to get to the system I'm working on today and I tried the recommendations - it worked like a champ - thanks a bunch for the help.
Does anyone know of a good site that covers sql syntax? I understand the logic of the code we just used, but not the syntax. I'd like to get a reference...
Thanks everyone for the responses - I definitely would not have come up with that on my own. I'll be playing around with it here today and will let you know if I have any problems.
Much appreciation.
-smf
I think this is going to be an easy question (and answer), but I'm not familiar with how to get it to work and I've been trying to figure it out for a little while now. Thanks in advance for any assistance - let me know if more information is needed.
So I have two tables, with relevant fields...
I thought about doing it that way, and it would certainly work if 'frmAddNewTransaction' was the only form accessing 'frmAddOwner', but I have three other input forms with essentially the same scenario (selecting the owner from a combobox or adding an owner via 'frmAddOwner' if the owner isn't...
Perfect - thank you both. It works great now. I added the first line of code from lameid in the 'On Active' event for the main form.
Forms![frmAddNewTransaction]![subfrmTransactionOwner].Form![cmboSelectOwner].Requery
I think the logic would be when the owner is added, 'frmAddOwner' closes...
I think this is pretty simple and my lack of knowledge with VBA is holding me back, but I've been trying for a few days and still can't get to work so figured I'd post the question. Let me know if anyone would like any other information. Thanks in advance for taking the time to read / help.
So...
Thanks guys for the responses so far.
The event I thought of was a button the user would click, but really it could be anything - doesn't necessarily have to be a button. The data being entered by the user will be in text format so it would be hard to validate it against any kind of input rule...
So I have a form with controls (text boxes) bound to an access table. I need to have the user input the relevant data into each text box and then after entering all the data, a user initiated event triggers the data to save to the table. I don't want the table to be updated at all unless the...
Have a user running xp sp1 and when he opens IE6sp1 he gets program error. Nothing specific, just generic send / dont send error message from xp. IE window never launches. Sys restore failed so I removed programs and non msft services from startup, ran spybot, pulled IE from registry, downloaded...
Are you using fdisk or the xp cd to format? I've seen similar situation where xp disk formatting fat32 caused problems. Used fdisk to delete / recreate the partition and 98 installed fine. Probly at least worth a try.
try each chip seperately in the memory slot that isnt broken. if the system boots with either chip in, they are both fine. if not, the one that causes it not to boot is the problem.
Try pulling the cdrom from registry and let xp reinstall it. I've seen this fix some strange cd issues. Delete upper and lower filters from this registry key and then reboot - HkeyLocalMachine - System - CurrentControlSet - Control - Class - 4D36E965-E325-11CE-BFC1-08002BE10318
When you configure the xp fax services you can pick the modem you want to use. In the setup of the xp services you have the option to pick the officejet as the fax device. This link may help if you want to use xp fax services...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.