Search results

Hi all, I have a form with two sub forms and when I enter data into one of my subforms I get this error? A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside of Microsoft Access. Then try the original...

hi all, I have this database I'm working on and have a couple of issues I can't work out. The first is this, I want to have my sub forms go to the last record when moving through the main form, currently I can only get this to work when I open the form? If I move through the records in my...

Hi all, I was thinking/hoping of using a list box on my form to store multiple values, I haven't been able to find a way of storing any value so far so not sure how easy it will be? How can this be achieved or is it just easier to use several check boxes (approx 8) Thanks

Hi, Would you be able to take a look at my database relationships and let me know if I've got them correct based on this info? Step One All the relevant and required information for a procedure is entered into the main procedure table. Step Two Once a review is initiated, the relevant data...

Hi I've been having this same problem for a while and I've had a bit of help here but none of the suggestions have so far worked. Basically I need a way to stop people tabing through a sub form without entering data. The sub form has a check box that has to be checked (it can't be set as True...

Hi, I have a form with a couple of sub forms, one of the sub forms only has a check box and a txt field and both are required before moving on to another record. I have this following code that works partly, but it only works if one of the fields have info entered. It doesn't however stop the...

Hi, I've split a database and the backend relationships are still intact but the front end they are not and it looks like this is causing a problem. Is this usual?

hi, we have this database that's used by differerent departments and one of the fields on the form has a combo box for status (pending / completed etc). when this is set to 'Complete' we would like to make sure that it can't be changed again, is this possible? there is only one table used in...

Hi all, one of the databases at my place has started acting really strange and was wondering if anyone knows what could possibly be wrong? there's only one big tble holding about 7.5 k records with approx 10 fields info that was entered yesterday has now been deleted (by access?) and when you...

Hi all, I have split a database, then realised that I needed to change two fields in a form. Y/N field and Text field. I went into the backed database changed the fields to be Required but in the front end it doesn't seem to work? I haven't tried re-linking them but should I need to? thanks

Hi all, I've got this form working ok but need to add some extra functionality but haven't a clue how to do it! http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=10175 The uploaded database has two main forms. The first is used to enter customer data, the second runs from...

Hi all, I've got this form working ok but need to add some extra functionality but haven't a clue how to do it! The uploaded database has two main forms. The first is used to enter customer data, the second runs from a query and shows all those records that have been completed in the first...

Hi all, Is it possible to run web pages from within an Access form? I've heard there's an Active X plugin that will enable me to do this but haven't found it yet? Has anyone used this?

Hi all, I have a couple of queries where I need to round down the numbers. I thought I could use the Rounddown function but thisthrows up an error. (Undefined function 'Rounddown' in expression) Does anyone know why this error would occur (and more importantly how to get around it?) this is...

Hi all, I have a report working and it can be filtered based on what is selected within the combo boxes on a form. When nothing is selected from the combo boxes, all results are returned and when a selection is made from any of the combo boxes only those values return. Excelent! The search...

Hi all, I have been working on a query now for about a month (you may have seen previous posts), different people have offered various solutions but so far none of these have worked. The closest I've got is with a Switch statement created in SQL view. The one below works ok: SELECT...

Hi all, Could someone advise on the correct query criteria I need to use to determine which records are between 4 and 8 weeks old?

Hi, I have one table but two forms to enter info into this table, when I enter data on the first form this goes on line 1 (record1) and when I then go to the next form and enter data, this goes on the next record?? How can I ensure that all records are on the same line... (I can't setup separate...

Hi, Not sure this is possible, and if it is I need a little help. In my DB I have several tables -Customer Info, Contact Info, Account Info etc I've been helped in getting a query to work that uses the IIF statement and has embeded IIF statements. This is all going well so far. My table...

Hi, I have a form with 2 sub forms and when I tab through the first form (the container) and get to the last record, the cursor pops into the first sub form which is just what I want, however when I then get to the bottom of the first sub form and tab to the next sub form but it doesn't work...