Search results

Thanks. I will look into the EAN: 128 code. I am heading down the path of what spikepl is talking about. eg i have a stack of pdf files from a document scanner, with arbitrary names. I want to rename the documents with the information in the bar code so as the name of the file matches the...

I guess i just thought of QR codes because i have been playing around with a qr reader on my android device. If a bar code would work better then cool. Do you know of any existing projects that have this sort of thing integrated with an access database? Ultimately i would like to have it run...

Hi All, I have a bit of a challenge for you :) My workplace requires me to process large amounts of quality assurance documents. They need to be printed out, usually using a mail merge each with its own unique document number. Sent to site, filled in, signed off by several different people then...

Thank you John, I your db helped me to do what i wanted to do. Just to elaborate in case anyone has the same issue as me. I didnt want to have a button like in the sample that john has posted so i used the after update event on one of the other fields in my form ie description. I also set the...

I am trying to fix a problem with a purchase order form. I need to have auto numbers in the item number field (which is in a sub form) but i need it to start again for each purchase order. Currently i am using: Nz(Dmax(expression,domain),0)+1 In the Default value field. The domain is a select...

Thanks bob, I will take that on board. I think i need to redesign my thinking before i redesign my db :s

Yea galaxiom, I thought that would be the way to go but i need to reference that number as a whole quite often for opening and moving docs, filtering sub-forms etc i know that what im doing is not the best database design since you shouldn't store a calculated field but i think it makes my...

Thanks john, i will have a play with those. I am still not quite sure how i am going to set this up, maybe an on current event will return the values i want from the string functions in the combo boxes... i guess then i wont have to store all the values, just have a unbound box for each...

Hi all, We have a convention in our company for naming documents that are saved in a "controlled format". I am building a database to keep track of these documents, authors, dates, revisions etc... The naming convention looks like this: ####-123-**** #### being a four digit Project Number 1...

I have found quite a simple solution to my problem. using a buttons on click event procedure, I ran the append query to get the new vendor name into the VendorInfoBase table. Then in the same sub i re queried the the VendorID Combo box and used the DMax function to make the value equal to the...

I'm sorry that you feel that way, but i assure you that i have not re posted this question... and i hope that it hasn't been asked before because that would mean that i am completely incompetent at using a search engine it also means that i have wasted 15 minutes of my time asking a question...

I am working on a form called frmPurchaseBase for entering incoming invoice data. I have a field called VendorID which is linked to a table called tblVendorInfo where all the details such as the vendor name, account details etc. VendorID is controlled by a combo box allowing the user to select...

Just following up in case anyone else has this problem. I found a rather easy way to do this by using the Movesize property. I just set an on open event for the form that i wanted to position then used DoCmd.MoveSize [Right],[Down],[Height],[Width]. It takes abit of trial and error to get...

Ok thanks, but i think i will need to develop my code skill a bit more before i tackle this one. Cheers

Could you possibly elaborate on how i would use this? i have pasted the clFormWindow into a class module in my db. im assuming i have to create some sort of on open event for the form i want to position... im just a bit stuck...

seems pretty complicated for my lack of knowledge, but i will see how i go :) Cheers

This is probs an easy question... How do i make a form open on a particular part of the screen and then be unmovable? I know about the Movable property, but how do i specify where the form is opens in the first place? Cheers.

Galaxiom- at the moment the sort of music i play consists of scales, twinkle twinkle little star and pleanty of finger drills haha i have only been playing for a few weeks. I hope to learn some modern music, maybe experiment with some production... i play an electric violin, its fun to plug into...

Hi, I have been posting on here for a couple weeks now and i am really happy with the info i am getting from this site! it is helping me out heaps. I thought since you guys take the time to help me out its only fair that i take the time to introduce myself. I am a 19 yr old lad from South...

I forgot to say, that i need to be able to move all the assets in a container when that container is moved. with out having to go through and update each individual asset.