Search results

Uncle Gizmo I am doing a eval on the Cellica Anywhere. Making a form for data entry. It does look promising but with 20 ipads in the field a bit deep in the pocket. I was wondering though if anyone has feedback from Microsoft AppOnFly that works with Access 2016. I saw a couple of things saying...

Thanks arnelgp. It seems to do the trick quite nicely, Just wondering How the Trim function makes this work.

Simple enough really! So I thought. A txtbox and I need the user to put a value of some sort in there so I know where the heck he is taking the equipment off to. You would think they would do that sort of thing but not. Can't do it at the tbl level as each of the boys have their own form with...

Got it. Thank you I have a text bx question but it may better suited in the forum event macros.

Hi Uncle! Thank you for the tip. Is looks as though they specialize in exactly what we are trying to achieve. What would the title be or the name of what they do"cloud services provider. mobile gag-it database communicator receivers. Joking aside with 20 Ipads in the field it may be rather...

Hi all, With a great deal of learning, and much of the knowledge coming from here, we have created a equipment tracking database [Check In, Check Out] sort of thing. many tables and many many more queries and forms. I put the back end on our server and the front on a few scanning station...

Hi Mark k thanks so much for your insight. I will get that going in the morning. ;)

Hi all, I think this to be rather straight forward but straight enough for me to figure out i guess. I have a pop up reports tied to my form so the usere can press the see list report of all the equipment they just scanned in or out of the building. I am useing the Date/Time data type (General...

CJ London, I can't thank you enough for sticking with me on this. I DID learn that vba extremely powerful and that you can basically do anything to your applications with it. I am going to get into more vba (on a entry level of course) but just seeing what types of things can be done has peaked...

CJ London, Please see attached file.

Hi CJ London, I deleted and re-entered the code you provided and I think my problem is that the combo-box on my form [BarCodeNumber] is a...lookup. I looked into the error 3464 Data type mismatch in criteria expression. and I think that my be the problem. Is there a addition to the code that...

Hi CJ London. things not going so well. I thought i may reintroduce some vital information to this riddle. the form name is Alexis_IN the table name is TransT the date field is TransactionDate the statics field is EquipOutIn the bar code field is BarcodeNumber I appreciate all...

Hi CJ London, I have been working on this today and I received a run time error 3061" too few parameters expected 1. I have looked into the error, i see one said that could be spelling and I went thru and rechecked everything but nothing jumped out and bit my nose. Also something about form and...

Wow I will give its go !! Thanks

Cj London, I made some changes on the code. Could you take a look and see if i got it. dim rst as dao.recordset set rst=currentdb.openrecordset("SELECT TOP 1 Direction FROM TransT WHERE EquipOutIn='" & me.combo & "' ORDER BY TransactioDate Desc") if rst!Direction="IN" then 'already booked in...

CJ London, I looked this morning for about 10 minutes and could not find it. I read it thou last night and even tried but I know that I most likely had it incorrect.

Good morning, I am hopefully able to start out on fresh foot. First attachment is my transaction tbl. The CrewChiefName is the auto number from the EmployeeTbl. The BarCodeNumber is the auto number from the ImportEquipTbl. The TransactionDate and the EquipOutIn are set from the transaction...

CJ London, Yes after reading the link I get it. Much better to follow the flow of a thread than wasting other peoples time if they are also spending time trying to help. Is kinda when going on a new job interview and they hand you a packet and say come back with your best answer to what's...

OK thanks guys. I am not sure if different people would be only into curtain topics, and I felt my question had a bit of overlap. but not a problem. i very much appreciable this resource.

I have a form with a combo box. I scan the barcode number into the combo box and it is entered into the "Equipment Out" report. My problem is if there is a lot of equipment be check OUT, the end user can accidentally scan a piece of equipment out a second time. I have run duplicate querys and...