Search results

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...

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...

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...

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...

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...

Good day everyone, I am designing a database and came to a screeching halt :( I have attached the db below for convenience. form in question is frm_InputProductionBatching What I have is: combo box Function, NumberOfItems, and Minutes in the detail section. There are three links above that I...

Good day, I am comming across a small problem that I am leading to think is the incorrect way to use the AND operator, although not sure. I have a login form with Username/Password/Unit fields. When the user Chooses their user name, Their Unit is populated by a hidden field. I have a code on...

Hey All, I have a field "NameView", irrelevant but it grabs a name from a seperate form from an ODBC connection. The purpose for the field is simply to grab the data from another form. On the same form As NameView theres another field "Name" This Grabs the data from NameView and writes to the...

Is there a copy function in a query. I need to copy a field from the direct previous record in a table and have it loop till the end. Any thoughts? Thanks everyone. Your time is appreciated.

Hey Everyone, I am trying to make a pivottable but need to organize my data fist. I need to somehow append the Operator Name to a field on the same record of Jobs processed Example Please see the database under "qry_Trim" Current: $BOGLE (sca) (cca) (cc2) (bal) (act) Want: $BOGLE | (sca)...

Hey Everyone, I have a number field of a check amount excluding the decimal point. Example 50000 Check amount is actually 500.00 Is there a way to insert a decimal point before the last two numbers? This is for a mass file, so an automated process would be delightful. Got my VPs breathin...

Hey, So Im trying to make a qry with some other criteria, but I need only the last record to be pulled when the qry is ran. I can't think of anything. Any help?? Much Appreciated! Thanks

Hey guys, This is probably gonna be cake for some of you, but it not workin right for me. I have this statement in a form under KeyPress What I need to to is Add another allowed Key, Backspace, Can someone help me code this? If KeyAscii < 47 Or KeyAscii > 57 Then KeyAscii = 0 Thanks!

hey guys, I set up a required field in the table properties with a Validation rule and validation text, When the field is skipped it yields an ugly error and will not let you pass the field. Where and what can I code to customize that error received? Thanks!

Hey everyone, I need to setup a search query where a user will input a check amount and it will search multiple fields. I have 9 check amount fields in a table and i need 1 input to query all the fields, I attached an example of what I need, Thanks everyone!

Hey all, I have 10 fields of check amounts in a table, Not all 10 fields will have amounts for every record, some customers will pay with different amounts of checks. i set all but the first's visible field = to flase on the report So I need somehow the fields with data in them for the...

Hey all, I need data in a table to be read only, once its inserted no one will be able to modify with the exception of a admin, how can i go about doing this/. thanks!

Hey all, I have attached here a sample of what im trying to do. Basically i set up a combo box in a subform where an employee will select his name. I want the selection to be made only once because that same person will be entering data for a prolonged period of time. I set up a linkchildfield...

Hey All, I can't seem to get this to work. I've attached a copy of what im trying to do in a DB. What I want is for an employee to pick his name from a combo box in the subform. I want the name to copy onto a field on the Main form so I can write it into the Recieved Table. I'm hoping someone...

I need a field to permit only numbers. Upon selecting number for the data type I select Long Integer for a longer number... But it only allows 9 digits.. I need it to allow to enter in longer numbers... Any help? Thank you very much in avdance