Search results

I see your problem. Where you've got Format Fixed delete it so there is nothing in the Format Field. I've just tried it and it works. I think it's something to do with when it's fixed format it displays 2 decimal places at all times regardless. I guess you'll be having roast chicken instead...

Create a form with a button and two text fields called PasswordFld and FileNameFld Copy the code in the code for the form (or paste it into a module it makes little difference) Then drop this code into On Click event of the button PasswordFld = AccessPassword(FileNameFld) This will take the...

What is the format property set to? That's all I can think of sorry... Bring forth the holy water.

I'm using 97 as well, bah progress is a dirty word. The only other thing I can think of is the number of decinal places in the Table design set to 0? The only other thing I can suggest is placing a dead chicken on top of you computer and perform a Voodoo demon exorcision. Sometimes Access...

Go into the properties of the combo box and under Format/Decimal Places change it from Auto to 0.

Is the form/subform open when you edit the table? It may just need some code to Requery your the queries on you forms. Otherwise check your relationships between the two tables. Just a thought. Not a very good one but a thought nonetheless...

I must have missed those "sunny" days...

Hi Allan You'll have to write your make table query in code as you can't do this with a normal make table query. Something like this should work. Dim MySQLString, BatchCode as String 'Insert your process here where you set your BatchCode value MySQLString = "SELECT * INTO " & BatchCode &...

Your best bet is to stick with my first option. Create the Check boxes on your input form and Bind them to the Yes/No criteria in the Tables. To go with your idea of using Characters to represent your attributes, while feasible, is not as easy as it sounds. You would have to go diving into...

I'm not sure I completely understand your question... Are all you contacts/mailing list details in the one table? If yes then create new Yes/No Fields for each criteria in your then bind Check Boxes for each criteria on your forms to these fields. You would then also be able to search your...

Half the fun of Access (Access is fun???) is finding out how most of this stuff actually works yourself. I've been looking (and learning) myself to the solution as this would be a great addition for something I'm writing at the moment. The solution (using VBA, what can I say, I'm a code monkey)...

Hi JONP Paste this code into your On_Load section of the form of which your control is on. MyControl.Value = MyControl.ItemData(0) This will set the value of MyControl to it's first row. Cheers

Not sure about the Calender as I've never used one before but the check box sounds simple enough. After the code that recognises the future date (I'm assuming this is either in the On Change or After Update event) place this line. Me.Repaint This should update your check box... Hope this...

I would store the random numbers generated in an array of fixed length, 12 items long. As the numbers are generated they are added to the list, however before they are added they are checked to make sure that the number you are adding isn't already in the list, if it is generate a new random...

Thanks guys. Placing the code in the After Update event does work but this code is only triggered after the user leaves the field ala Lost Focus event (or selects the option from the combo box). Does anyone know whats actually happening? Is there any point in having an On Change event if you...

Hi Folks, Have a problem that has jinxed me for a while. I am using a Combo Box to select a customer and in the "On Change" event I have VBA code that takes the value of the user input in the Combo Box and uses it as part of an SQL query to populate various Fields depending on the input. My...

Probably your best bet is to go and look at the Knowledge base at http://www.microsoft.com/office/support/searchKB.htm You'll need to get the handle of the desired window (using the FindWindow() method) then manipulate as required. I tried to find info on actually shutting the window down but...

Just use this instead, much easier and foolproof(ish) Set db = CurrentDB

Could it be these three lines? Set recADJSYSMaster = Nothing Set recADJSYS = Nothing dbs.Close I always do my clean up code the other way around. recADJSYSMaster.Close recADJSYS.Close Set dbs = Nothing My understanding is that the recADJSYSMaster and recADJSYS are just references to the...

When you open the Winamp.exe I'm pretty sure you can supplly the mp3 filename as a parameter that will make it autoplay the song. Let us know the outcome as this sounds like a great idea...