Search results

Hello, I wonder if any body can help. We are using a Pervasive database using GUID. I would like to link tables from this backend into MS Access, which i know how to do. However, as the Unique ID's are in GUID format, they are represented with funny characters not the GUID. The application...

Hello I have created a database which uses pictures, but not OLE, this is so that it will allow me to use a path to the picture but when the pictures are changes as i go through the database, the database crashes or the program just exits. does anybody know of a way to display pictures using a...

Hello, I have a couple of questions. I have a form which has a List box displaying records where the a Field called Select is set to False. I have put a subform on this form which is a continues form linked to another query from the same table as above, this query shows all records where the...

Hello, I am creating a Stock database, the Stock information is coming from another application being imported from Excel. The excel spreadsheet contains your general stock information and also a path to where the image of the product also is. I would like to get Access to read the path of...

Hello, I am using office 2000, i am developing a database, how can i add a feature so that users can only use part of the database until they have entered a password. and also is there anyway of stopping users pressing the shift key to bypass the viewing of the main screen etc.. thanks in advance

Hello, Does anybody know of a way which will allow Access to read the text from a Web Page (html). Is this possible?. Thanks

Hi, I have a form which is used to search stock records, The results are then presented in a List box. From this list box i would like the user to be able to select a particular record and click a button (or double click the record)and update another Query (Table)which is gathering information...

Hello, I have created a form (Access 97) where i have a field called Short Description, i have created another form that is opened from this main form, which displays all the short descriptions entered for a particular customer. I would like to be able to open this description form so that the...

Hello, I want to create a Query by the user being able to select the criteria using a form. ie, if i have 3 tables, i want to search for an item which is determined by the tables, how can the user enter specific criteria i,e Table 1 (field) And Table 2(field) or Table 3(field). I think it is...

Thanks for the help, I have used many ways to update the Time and date , using Onfocus of the Log notes update the Date /Time, but if i return to the log it changes the date/time again which it should but i dont want this to happen, i want the original date and time entered to stay as it is...

Hello, I am creating a database to log calls, i want the date and time to be entered as soon as they start to enter data. What i want to do is that once this information has been entered the date and time for this particular log can not be changed in any way, hence once the date and time have...

Hello, I am creating a table with contains a list of stock items, along with the stock description i want to add a picture to it. I can do this by inserting a OLE object. But i want to add a browse button so that the user can search for the file to be shown, i.e picture. How can i add this...

Hi, I am using the transfertext method of automaticly import data. On the form i want the user to have the option to specify a location of where the file is, rather than having to hard code the path of file. Can this be done? if so how. Thank All

Hi Robin, Thank you that does sort of work, but the problem is that i need to then export this information to a excel spreadsheet, I will explain. I have imported 2 spreadsheets i am then comparing the stock codes if they match i want deduct the quanties and then show the difference. The...

Hello, I want to write an expression to say.. If a value is a negative value then change another field to say 'IN' if not say 'out' I want to know how can i, in code decribe a negative value. Can any body help? thanks

Thanks for the advice, I have tried this solution, how do i match the stock codes together.. and if no matches are found then the item must to be presented in the other spreadsheet. Also once i have calculated the difference how do i assign the difference as either in or out. sorry i may be...

Hi, I will explain what i want to do.. you may know of an easier way. I have two spreadsheets (ms excel). I want to import them into MS Access and compare the stock codes. A stock take situation. If they match then subtract the Qty's, if the value of stock is less than the value in the...

Hi, I have a form which includes some of the following Right Format When i try to execute the prodedure with these two statements. I get a message saying they have not been registered. I have tried to follow the help but i cant access the Reference option under Tools>references. Can...

Hi, I am developing an application is MS access 97. The problem i have is that i must have created a macro called MainSubMenu a while back but deleted it. When i assign the application to open up so that no end user can touch the tables, forms Queries...etc and i right click anywhere on any...

Hi, I get this message on various parts of the database i have created, some code that has been used is from other sources - web etc. I get this message Cant Find Object or Library. and then that part of the application does not work.How can i resolve this problem. I also get this message...