Recent content by maxxximaniac

Hey All, I'm trying to have the checkbox keep its original format in a make-table query. It switched the format over to a 0/-1 FALSE/TRUE and would like to keep the checkbox. Any ideas on how to change the field type utilizing VBA? A Calleuge of mine came up with this, but it's not working...

you can put an if statement in the Pageheader OnFormat event

Nevermind, solved it with a page break in the detail section... Thanks for your help guys!

I'm printing it, otherwide I'd try a form :(

Hello all, I have a report bound to a qry. What I'm trying to do is just have the detail section report for each record. Pretty Much I need it to act like a form in a sense, where the header/footer don't change but the detail section changes when navigating to the next record.. Any Ideas...

on close event of the report... you can run an update qry to change the y/n from 0 to -1 or whatever... DoCmd.OpenQuery "qry_Update"

Ah! I get the logic.... Works like a charm! Thank you ;)

Hello, Tried a search but could'nt come up with an answer. I have a number field with an amount. The format will always change as far as the LEN is concerned. I need to remove the decimal. There will always be 2 numbers to the right of the decimal but the left will always change. Example...

Great, worked like a charm, Thank you! :)

Hey Guys, I Have a combo field, ComboFunction, where if the value = "Misc" then a memo field appers, txtMemo. txtMemo must not be null if ComboFunction = "Misc". I am not sure where to put this event code or how the proper way it would be written. It must be in the form and not the table...

Yep it looks like it worked... Set the focus to the calendar. Run the today command then set focus somewhere else if you need. :)

Well, I'm not quite sure if it will help, but it seemed to do the trick. CTRL+t sets the calendar to today's date. I noticed it only works when the control has the focus. On load event, I setfocus to the calendar, ran the control.today command and it seems to do the trick. We'll see tomorrow...

Hey, I'm trying to get the calendar control 10 to default to today's date when the form is loaded. I searched on it and came up with instructions to place the "Calendarcontrolname.Today" on the form load event, but its not working out. It saves the date that the control was added. Can anyone...

I tried doing this but when i enter in say amount of minutes for the 1st pretermined field, all the others become the 1st row's value, because all the fields are bound to the same place. Then the default values disappear and become what was selected first.

I'm sorry for not giving a better explanation.... I attached two pictures below... 1.jpg Is my current form 2.jpg is what I'm trying to do. Basically, The three fields in the middle are where a technician needs to enter in data. Each field is bound to a table. There are about 50 values in the...