Search results

I am thinking of implementing barcode scanning in one of my Access 2010 databases. It currently prints out barcodes using font but I would like to improve on that further. 1) Barcode Scanners Am I right in saying that these devices should work the same as any HID devices? I.E once scanned it...

2 words. Explosive diarrhea. I should be really using up my work from home priviledges but unfortunately that's causing aggro in the office :(

Upload what you have and I'll see if I can fix it :)

I am currently testing upgrading our database backends to SQL 2012 express. It's all still very early stages but I would very much like to lear more about this. I would like to say I am fairly proficient with MS Access (07/2010) and also have good enough grasps of programming (C/C++ and VBA)...

Check your form is the object "PalletNo" exists. Also looks like you got an extra ' somewhere.... try "',palletno = '" & Me.PalletNo & "',palletcmnt = '" & Me.Comment _

Welcome :) Are you a developer or a poet? :)

Try populating your tblParts with some data. Populate all tables with data actually and retest. It's to do with your Referential Integrity check. So no record in tblParts means you cannot add new record in tblCalculation.

Indeed. I'll have to add that JET is pretty good at most stuff that I throw at it but when the data + users increase SQL is the way forward. Need a bigger dev team though to undertake this task :P

Glad I am able to help :)

Well normally I'd just run a query to return the results of the tables individually and visually check if there's not null fields. You can write a custom query too if you have a big table :)

Try this : 1) Create new form and set your table as teh recordsource 2) Create 3 textboxes with date checked, vip pass and vip fail date as their control source. You might want to create a combobox with Yes/No for "VIP Pass"... 3) Select the textbox for VIP Pass and create a code for the...

From experience this could be caused by a null value in the union joins... check that none of your tables are returning null.

Try : SELECT [Standards Check record].[Date Checked], [Standards Check record].[VIP PASS 1], [Standards Check record].[VIP Fail date] FROM [Standards Check record] WHERE ((([Standards Check record].[VIP Fail date])=IIf([VIP PASS 1]=False,DateAdd("d",90,[Date Checked]),"")));

Wow... it seems that if we do go SQL I would have to basically re-write 80% of the FE as most if not all the queries are formed for JET... Just not something we have the resource to do at the moment but from now on I will be careful in designing new databases to make sure it's very SQL compatible.

Glad I've found this thread. I'm experimenting with implementing an SQL backend/Access FE but still learning how to update the queries and my database is split into FE/BE at the moment. One problem is my queries somethings use custom fucntions and also input from form textboxes so I'm not sure...

There other thing I would also check is that you don't open the database in "Exclusive" mode. If you are using Access 2010 this option is under Access Options > Client Settings > Advanced. Changed it to Shared and also consider Default Record locking to "No Locks".

Changing name works! Although I need to tidy up some of the code especially ones using DAO/ADO stuff but at least it works! Just have to figure out how to avoid changing names during upsizing as some of my databases has over 30 tables :P

I'll give that a shot after lunch but I don't think it will be that easy ;) It seems that it'll be easier if upsizing from non-split DB instead. I've Googled and so far can't find any good answer to my conundrum... It will definitely be hard work if I have to redesign the whole front end...

Hmmm do you mean something like : dbo.tblCustomers -> tblCustomers (orignal name) ? Not sure you if you rename SQL tables that way within Access?