Search results

I am using adp to front end a SQL server database. When I open forms and specifiy a where condition it seems to set the server filter property of the form to my condition. If I then open the form to create new records or edit a whole recordset the filter is then applied. Is this a feature or a bug?

I have two tables tbl_engineer & tbl_user. Potentially the people in either table can be trained. I'd like to store details of this training in tbl_training. So my question is; How do I create a relationship from tbl_training to both tbl_engineer & tbl_user that ensures RI?

Good morning I have a list box with a SQL server view as the data source. I want the dataset to be filtered to include only results with a particular foreign key which is stored in a field on my form. I can do it in the behind module by programmatically specifying the row source but I'm...

I have an MS Access database where the tables are held in a backend on a file server and the forms, reports, queries, etc are held in a front-end which is distributed to each user. This has worked fine up to now. I now have a requirement to access a number of MySQL tables that are held in a...

I have some cde in which I'm trying to ignore error 3349 whenever it occurs. The code ignores it fine the first time but the second time the error occurs the code does not seen to go into the error handler. Can anyone help? Private Sub butGo_Click() Dim db As DAO.database Dim tdf As...

We have an Access Database split between front and back-end. The BE is 50Mb and the front about 60Mb. We have a requirement to provide access to the database to our other branches all of which have broadband. I have been trying to find out the best way to achieve this over IP as we do not want...

I have designed a software package based around an Access Database at my company (based in the UK). There is a good chance that the company will be able to sell the software and potentially make a handsome profit. My boss wants me to sign an Intellectual Property Rights agreement. Does anybody...

I have a main form with a subform which in-turn also has a subform (in datasheet mode). When the user clicks a button on the main form I want to disable all of the controls on the subforms. This works fine until the user clicks the button while the focus is on one of the text fields in one of...

I have an address table which had five one-to-many RI relationships with other tables. I recently added two more tables/relationships and it seems to have slowed down my database. I made other changes at the same time so can't be sure. Would I be correct in saying that this is something that can...

I have a form with a query based bound combo. The same combo can be found on another form which can be launched from the original form. I want to update the combo on the original form with the same value as the combo on the launched form (after update). In my after update event I have the...

I have a query which has a form field name as part of its criteria. There are two forms which access this query from their onload event (its a delete query). I would like to vary the field name in the query dependant on which form is executing the query. i.e If form 1 runs the query I want to...

I've developed a report which uses code to set the properties of a picture control in-flight. I use this method to display unbound jpegs. Occasionally a file name is incorrectly entered and when the report runs it fails because the file does not exist. When running the report in form view an...

I am writing a complex report which contains 18 subreports. I have been suffering problems all along with errors related to the number of databases that are open and seemingly the amount of memory being used. Essentially the report is all based on data from a single query but because it needs...

I have a form with a subform with a subform. All of a sudden the second subform has stopped appearing on certain records. Yet if you go into design view and back into form view and select the same record its back again. This form has been heavily redeveloped recently and the table that it is...

I am getting error "too many databases open" when running a new report with 20 subreports. Does anyone know what causes this?

I have a certain set of tables in my database that are used in a particular section only but keep reporting the following errors; Not a valid bookmark The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time...

I have a "search form" which uses combo boxes to select records and display them in a list box at the bottom of the form. There are five combo boxes all accessing one field from a table using a query. The list box is based on a cross table query of the five tables and uses the values in the...

I've got a label followed by a variable length text box followed by another label. How do I format my report so that the second label moves left or right dependant on the length of the text box? i.e My name is [text box] and I'm pleased to meet you. How do I get pleased to meet you to move...

Hi all I am compiling a report which will have several pages (about 12) of text containing variable data followed by a variable length section of 1 record per page and finally a conclusion, again with variable data. The report builder seems to restrict me to 55cm in the report header which...

I've got a listbox control on a form which I'm populating with a query each time the form is loaded. The query will only ever select one row. I would like to place the contents of the Listbox control into a string but I'm having real problems. Despite the fact that I can see a value in the box I...