Search results

Hello It been a while since i have been on the forum. I developed a database last year and since then i have moved to a MAC. I would like to know if there is a quick and easy way of converting a database to application which works on any PC or MAC which does not have access?

Hi I am developing a little spreadsheet where i have a worksheet where i have a list of names. When i new name is added a new worksheet is inserted into the workbook with the new name. i.e if Joe Bloggs where added a new worksheet will be added called Joe Bloggs. I want to do this in VB...

Hello For some reason Access will not allow me to open any mdb files. When i click on the file to open Microsoft opens the install wizard for office 2000 and asks for disc 2. If i press ok its says DATA2.msi is missing. However if i open access through the Programs menu and then go and...

Hello I am creating a DB which needs to have a particular table filled in before you can proceed. For example when the database is opened for the first time the user must enter in some information about themselves like and address etc.. before they can go to the next part of the database. The...

Hello I have a button which opens a report in print preview. Is it possible to have the option to print the document or convert it to PDF so i can be attached to an email etc... I know that i have to use either flash paper or snapshot view but how can i give the user the option from a...

Hello I have created a DB which has a front end which is linked to a backend where all my datas kept. I want to install my database via cd-rom using and install wizard. If i ask the install wizard to c:/user/programs/ would i have any problems with the links between the front end and...

Hello i want to create a tracking number based on information entered into a form. So i have my main table called "MainData" and this is in the backend and linked through to the front end where my form is. I then have a query which is called "calllog" which has a field called "Call Number"...

Hello I have a database which i am constantly updating and improving. I have a few friends who use the database in a current form. If i made an update say to a form or to some of the coding to make the DB more efficent, how can i update the dBs my friends are using without damaging or...

Hello I am racking my brians to work out how to upload a jpeg from my c:drive into a field called "image" in a database. I can not workout how to do this, could anyone help??

Hello I am in the process of creating my first commercial databse and i was wondering if anyone new where i can get a template of a generic user licence text? Any assistance would be appreciated.

Hello I need some assistance. I have built a query which i have built two forms which are slightly different. Is there a way to make each form only filter on the data entered in by that form i.e Form 1 entered ABCD Form 2 entered DCAB When open form 2 i only want to see DCAB? Is this...

hello I am creating a database for a client and i only want them to see the forms that i have created so that they can not see the queries or in fact i have used Access. Or may be make it look like a web browser Does any one have any suggestions?

Hello bit of a stupid question. If i create an access database and my friend wants to use it on his apple mac would access work if created on a PC or is there any special patched i need?

Hello I have a spreadsheet where i have to count the number of claims which have been made. For example i have cell b2:b6000 inwhich i have a list of valables which would be 601 or 602 i then i have cell g2:g6000 which has claim and no claim. I want to find out the total number of claims for...

Hello I have a spreadsheet where i have to count the number of claims which have been made. For example i have cell b2:b6000 inwhich i have a list of valables which would be 601 or 602 i then i have cell g2:g6000 which has claim and no claim. I want to find out the total number of claims for...

Hello I am stumped on how to get a query to do the following: I need to count the number of days which have fallen between a date range and then work the charges incurred both actual and projected. The date range is >date()-7 and date()+7 Is in basic terms the last seven days and the next...

Hello I have to work out how much money we owe a supplier. I have a report which in cell E2 i have a the start date. We then get 22 days free in which i have create a cell J2 I then want to find out from the end of the free days to the current day how many days have past and then i want to...

I have successfully created a user id & password prompt which works excellently. The database i have created has three forms inwhich two departments access. I have an issue where one department is only allowed to view a search screen and the other department is allowed to enter in information...

hello i have a a form inwhich the user can send an email to all suppliers. The list of suppliers is some 150. The code i uses works but it will only do the first 10 email addresses. I have had a little play to see if i can make it send the lot with no luck. Does anyone know how to make...

I have to database where people enter information and some times miss entering in a field value called [Scanned Invoice] the db automatically gives every entry a date. The first part was find out which jobs where missing a [scanned invoice] 24hrs ago by making a query [scanned invoice] Is Null...