Search results

Hi guys, Just a quick one ( I think ) I have a table which already has an autonumber ( the id field ) But I need to create another field also with an auto generated number which will generate reference number which i need to start at a pre-defined number. The problem is, im not allowed to use...

Hi Guys, Just a quick request for a bit of help. Tries a few things but didnt work. I have a form which has an employee start date. What I need to do is work out the holiday entitlement of each emplyee. The math behine this is, if they have been here less than a year, we do the following. 20...

Hi guys, Just a quick one I`m hoping you can help me with. I am just about to start a new DB, but there are a few things I need to sort before i start. I am working with a quotation system etc which will require the use of unique IDs... eg 000123 then 000124 etc, this bit is not a...

Hello all, Im trying to distribute my program using access runtime. ( which I have ) But I cant find the Packaging Wizard that I need to create a distribution file. Im sure I have the developer extension, as I have the Full Blown office 2k3 pro. In my old office 2000 developer, this wasnt a...

Hi guys, I have already a database functioning how I want it ( which is basically an installations and costings database ) I have now been asked to create a database that can do things like marketing reports, sales costings and advertising tracking etc etc. The thing is, if the customer...

Hi All, Just a quick one. I have access 2003 installed, which I use to make systems ( doh ) Anyway, I have just installed Access Runtime on the same machine so that I can test my databases on the runtime version to make sure that all works ok. However, I have installed several times now, but...

Hello All, I have a quick question that I cant seem to find the answer to in any of my books. I have a line of code that I would like to change. The code points to a default path of C:\My Documents\ Now, the problem is, that on some machines, windows is installed on G: for eg. [Code]...

Hi Guys. I created a macro which I then converted to a module ( Not the best thing I know, but I have VERY little knowledge of VBA at the min ) Function mcr_archive_data() On Error GoTo mcr_archive_data_Err DoCmd.SetWarnings False DoCmd.Hourglass True Beep MsgBox "You Are...

Hi Guys, I have searched the forum, and not really found the answer I`m looking for. I used in my Database, a postcode field, which for 90% of the postcodes I input is is fine. However, som of the postcodes dont conform to standard post codes. I`ve found some info in this link...

Hi Guys, Im about to create a button on a form that will archive the current record to an archive table..... The question is, Before I start to look into this, I would just like to clarify what I do. I assume firstly I would need to make an exact copy of my current table, them remove all...

Hi guys, I have a bit of an embarrasing question, as I`m sure that this is so easy to solve, but its just beyond me... I have searched but dont get exactly what I`m looking for, looked in all my books to no avail !!!!! I have a form, which had many data in it. I have a particualr feild...

Hiya guys, I have much help from this forum during my latest project, and all help has made me progress at a nice pace....So thanks guys. The latest problems I have is to do with command buttons. Really simple i`m sure, but could not find the answer in the search. I have added a command...

Hiya Guys, I have been using access for sometime now, but feel restricted to the look and feel of the system. I have decided that I would like to learn Access VB & Visual Basic, but have not used either before. Does anyone recommend a good beginners guide to any of the above, and if there is...

Hi guys. Just a quick one, I couldn`t find anything on this or in any books I have. I`m assuming I need to create an MDE file befire I can distribute my database for other people to use ? Anyway, that I have done, but the question is, I`ve done this and have a select number of ppl using my...

Hiya Guys, Just like to thank you all for all the previous help I have recieved from this forum. I have reached another snag :eek: I am trying to show a field in a form which will be the sum of some data in a sub form ( Which hols data in a seperate table ) Anyway, The Relationshiop to...

Hiya guys, I have just been asked to add a reminder function into a database, I have searced the forum, but not sure what I`m looking for. When we deal with customers, some times we have to contact them again at a later date. Is there anyway that we can get a reminder to popup, or send a...

Hi Guys, I`ve searched the forums, but not knowing the terminology, i cant find what I`m looking for. I have a table which is use for a drop down list in my forms. This is saved into a table, but shows up as a numerical instead of the name value. Also In reports, I get a numerical value...

Hi Guys, New to the forum, and its nice to see how active this place is, and upto date. My question is, and probably simple to correct. ( Please be patient with me, i`m new to this, and my terminology might be incorrect, also please simple answers ) I`ve searched the forums, but as my...