Search results

Sorry probably did not explain my self i know how to see who the user is i just need a way to tie a message to a certain user via entering both in a table so i dont need to rewrite the code everytime either the user or message changes.

Hi all, Just a question which i hope you can help me with. If i create a Table "tblMessage" with the following fields "Username" and Message". Within the above table there is a message for username() "smithj" how would i get the contents of that message stored in the above table to be shown on a...

Ajetrumpet / Adam Thank you for taking the time to help me with this one, as i am sure you have gathered i am very new to Access but i am trying my best to self teach by setting my self challenges. However more often then not i have to turn to the skill and knowledge of others like yourself on...

Hello all, I have a problem that i would be grateful for some help with. I have a form which is called frmMasterNum which has 3 Textboxes called txtFrom, txtTo and txtTotal. What i am looking to do is if i put "10010" in txtFrom and put "10015" in txtTo when i press a button the above numbers...

JR, Thank you so much for your effort and time, i have gone with the first option of creating a table and setting incerting a value to allow the Combo boxes to filter by. Its seems the cleaner and simpler option.

Thank you for taking the time to help, i think the best thing here for me is to try it and see where i get with it. I see you point about the recordsource, as it will be a common value to filter on.

If anything else is shown in the Textbox then the other values in the Combobox situated on the Subform would be available to be used. Are you saying when you have the initail value of a Cascading combobox on a form and the final combobox on a subform then there is nothing different in designing...

Hello, I was wondering if someone could take a look at my problem as i as struggling to come up with a solution. Is it possible to restricted the possible options available in a Combobox dependant on the value shown in a TextBox? Eg: A form called "frmmaster" has a Textbox called txt01, there...

Gents, Thank you for your feedback and support in my problem, the code is now working correctly.

Hello, I have an issue with a If statement that i have wrote, it is looking at the system time which i have set using the correct format but i get the feeling i have other looked something very simple. I would be gratfull if someone could have a look and feedback any suggestions. If Me.txtTime...

Kiwiman, As soon as i get to work i will try this, either way i will get back to you. Thanks for taking the time to help me.

Option, Thanks for replying, as soon as i start work later i will post a copy of the Database as i work nights.

Hi, i have looked on the forum for this and i am slightly confused as it look like either you need to add a module to preform this action or a Union Select Query?? and i am not sure if i am looking at the correct Posts. What i am trying to do is on a form with a Record source called...

I am sure i will need your help, so thanks for offering.

George / WayneRyan, Thanks for asking after all this time, sorry i did not reply to you earlier as i have been spending most of my time at college doing additional courses like Crystal reports and a couple of beginners courses in Networking. The project i was working on back then was a Holiday...

Bob, I can see the benefits of using this over an IIf statement,so thanks for suggesting it. Steve

Brianwarnock, Thanks for the statement, i looked and looked at the IIf statement and never saw it once, it was driving me mad. Even split it up to try and find the error. This is another example of the support and understanding i have always received here at AWF. No matter how silly or complex a...

Hi Rabbie and MSAccessRookie, I am so sorry for wasting your time, as stupid as it seems when i wrote the question on here i corrected it without realizing. My error was that when i created the query and did not use "" on the lettering. Once again so sorry, just goes to show sometimes it pays to...

Hi, I have had a look at other posts on which i have attempted to create a IIf statement in a Query but it will not run. It shows a error message saying about the bracketing or a syntex error. I would be grateful if someone could please have a look at it and lend some knowledge to me as i am a...

NigelShaw, Sorry for delay as it was my Birthday weekend, i have decided to redesign the Tables and forms. From reading your reply that would confirm my action, By all means if you have a possible solution or example that would aid me i would be very grateful. My weakness is code, i have just...