Search results

Hi Guys, Attached is an Access 2007 DB which I am experimenting right now, I am lost on how to open the frmContactDetails based on the selected hyperlink on the frmContacts, I created a macro to open the form but it shows the first record not based on the selected value on my frmContacts. BTW...

Hi guys, Hope this is not a late response, I had the issue when I initially installed my Office 2K7 and was frustrated for the whole week to find an answer, finally called Microsoft Tech Support and instructed me to run Access 2007 in safe mode: Go to Start -> Run -> type msaccess/safe Then...

Thanks Neil, figured out that I have the wrong reference. my bad.

Hi Guys, I would like to request the community for their help on this one. On Access 2007 there is this cool feature when you open the supplier form, its a datasheet view, when you add a new record all you have to click is the "New" field on the ID. My question is that how it was implemented...

Hi, I stumbled upon a site (http://www.access-programmers.co.uk/forums/archive/index.php/t-146119.html) and have this code tested: ... As to your problem. Create two fields in your table: TheYear - long TheSequence – long Then enter this code in your form's BeforeInsert Me.TheYear =...

Hi Paul, Thanks for the info. can you give me an exact example? sorry I'm still new in Access. Hope you don't mind. Thanks. Jeff

Hi Guys, First, I want to create a sequenced number to be placed at the end of a time stamp then after every end of the month this number will reset again to 1. I've got the time stamp working but can't figure out how to include the sequenced number & reset it to 1 after every beginning of the...

My pleasure, good luck!

Hi Pat, Thanks for the encouragement, after so many hours here is what I have so far (pls. see attachment for details). Please let me know what I messed up. Thanks again. Jeff

Hi Pat, Thanks for the enlightenment, Believe it or not I consumed the whole day yesterday just trying to normalize the data but still can't get it to work plus the fact that I need to do some form design :( I am really running out of time on this one and probably if I can't produce the result...

Hi jlabre01, I've attached a DB just to give you an idea, sorry for the naming convention have to do it in a flash. Hope this helps. Jeff

Hi Guys, I have a new task which is to design an order tracking for our company using the attached excel format. Having hard time normalizing ang designing the interface since the user requested the form to be as easy as the excel since they are used to it. You help is highly appreciated...

Hi Mike, Tried that route, but it does not work if the the default resolution of the screen is 640 x 480, what I am thinking of is how can I get the native resolution of the screen so that I will just put a condition whereas: select case resolution case 640x480 form size is set to 640x480...

HI DCrake, Thanks for this zip, tried it looks OK so far, what I am thinking is something that upon loading the form it automatically adjust to its resolution. Cheers!

Hi Guys, Been searching on the forum and on the web for a week now but seems cannot find the solution on my problem. Recently deployed an application in our office (Order Tracking) works well then a new guy came and set his screen resolution to 640 x 480 coz he has having problems with high...

Hi Bob, Thanks for the quick one, I do set the location to be a trusted one, what kept me thinking is that when I open the 2K3 version it works flawlessly, it triggers the on load event whenever it can't find the BE.

Hi Guys, It's been a while now but seems cannot find the solution on the re-link of my BE in 2K7, the application was and re-linking was working perfectly in 2K3 but when I tried to upgrade it to 2K7, it wont trigger the On Load event which has the function to check the links, it simply pop-out...

Hi guys, I know its annoying on this topic, but I do need a to come up with a user level access in access 2007, Ok, here's what I envision upon logging-in to the system the user is limited to specific tasks (e.g. record viewing only, printing reports only etc. etc. Certainly seached the...

What version of Access are you using?

Hi Guys, Figured out it was a bug on my MS-Office 2K7 version, just in case someone is sufferring from this dilema a guy from MS Tech Support emailed me possible solutions: 1. Go to Run -> msaccess /safe 2. a little bit messy, since you have to edit the registry, just in case the first one...