Search results

My first post in SQL server. I downloaded SQL server 2008 Express x86 and at the moment I want to try and learn on my PC only and my aim is to connect some of Access database to use as fron end and back end I want to make SQL server. Now when I connect, I use the server name as local in...

I am just curious if an Access database could be used in process control equipments. Say, capturing some signals from sensors, recording etc. If MS access as a whole is not preferred then could it be used with some other platform. Being a process guy, just wants to make use of Access as much...

I have been using a continuous form and using filters at header. When there is no data after search, combo filters also go blank and as per AllenBrowne site, this is a bug. http://allenbrowne.com/bug-06.html I tried to use the suggestion by Allen Browne but could not succeed, does somebody...

I need some help relating to updating a date field in a table. This field is updated by below code: The date field is updated in mm-dd-yyyy format whereas our system dates are in dd-mm-yyyy format. In this forum and on google, I found that VBA's default date format is mm-dd-yyyy, OK, that's...

I have used following code in a form to change a text box on another form's default value to change. Code is working fine but when I convert the .accdb file to .accdr, it says "Error 7802 This command is not available in .mde, .accde" I understand it might be due to I am opening another form...

I am using following code in a text box exit event to find matched text in a list box. What I need is when exact text is not found, a message box to display and some other actions but I am not finding correct place to keep those else commands. You can see else commands in ' appostophe. May...

I have two unbound list boxes and both contains many records (~100). Those list box row source is a query which contains a field bottleID which I have used in my dB to get the bar coding. When I move focus to any of list box and then scan a printed bar code, focus does not move to correct code...

I am running an update query based on the form's bottleID field but it update all the record of that bottleID. That bottleFK has many instance in table transaction and I want to update only last entered record. To track the event, I have TransactionID and loading time in tblTransaction. I...

I want to update a particular bottleFK's last entry of a table from a form's reference but it updates all the bottleFK records of that table. Can somebody help to find what is wrong here. regards.

Please support by advising on what is the best way to design reports suitable for barcode sticker printing for my issue described below: I have set up a report which uses a bar code font. Upto report stage, everything works fine but when I need to print on a thermal printer Make Zebra 2844, the...

I am exporting a report from access. The problem is after export to .rtf, all fields appears correct except a bar code field (CCode39). It adds a space after the text which makes text non-recognizable by bar code scanner. If I use other formats, then there is no problem. I tried by using plain...

I made an access report with bar codes. The bar coded report appear correctly on A4 size paper. I deployed this dB on another PC which has Zebra bar code sticker printer. There, I need to change the paper size otherwise many prints appear on the printer for one A4 page. I could not find such...

I need to generate new records in bulk. I searched this forum and net and at last the below code worked partially to my requirement. I call this function from a button on the form in which I need to fill various field first and then fill desired row count then I need to generate new records...

I am making a small database on a process which involves loading a product on a machine, unloading after a minimum time. Reloading is also possible of once loaded item. When a product is loaded on a machine, user name, machine ID, date is inserted. This seems doable but what if this product is...

I am using following code in my dB. DoCmd.SelectObject acTable, "tblUsers", True DoCmd.RunCommand acCmdCollectDataViaEmail Works fine. But I have further actions involved after this code. If user press Next on the wizard opened by second line of code and progresses further, then it is...

I am first time trying to use temporary table in my application and need support. I have made a make table query which creates a table in front end containing record filtered by form's current record. Then, I use data definition query to generate a primary key in this table (This is a...

I need to concatenate the fields of a form and subform. I have established one to many relationship in two tables. One is record source for parent form and Many part is for subform. Main form has fileds such as: Department IndentBy ApprovedBy Subform has fields such as: Material code...

I am using collect data via email process to collect data by email, purpose is to update not to add new records but to update. The condition for update is to have data from one table only. I have 4 tables data from which should be sent by email. These tables are related. I made a query based...

I want to collect data by email using this feature of Access 2007 but that needs to run a wizard. I need to automate this process through a code, please advise me the best way to do it. I would like to build a button which should send the email to collect data by email. In my earlier post, I...

I could make a fully functional small database with the help of all the experts in this forum. Eventually, this database becomes so effective that we could stop one paper format completely. Now, I am exploring this dB to another one step further. To do so and to make the process paper free, I...