Search results

Hi all, I have a report with 2 subreports in the Detail section and the caption of one of them still shows up in my reports print preview even though I have cleared the captions for the subreports. I have no idea how to get rid of this ghost caption. I do not see the captions in report view...

Hi all, can you create a fixed one to three relationship between tables in Access 2007? So far I have only seen one to many relationships...

Hi all, Does any one know how to refresh library references through VBA? I found this code some time ago (cant remember where, sorry), but it does not seem to do the job. Please have a look and see if you can get this code to work, cause I have not been successful. I tried to check for error...

Hi all, Does anyone have a database lying around for registering and rating wines? If not, I will just start from scratch and maybe if it goes well, post it here in the Sample Database section. Cheers!

Hi, I have a access 2003 FE and sql server 2000 BE. One user of the database gets the following error message when he tries to connect to the database. This is probably very simple but i am not figuring it out so please let me know if you have any ideas. The picture is not readable so here is...

Hi all, I had this problem happen to some of my users when I released my front end .mdb to about 50 users which meant that i had to go to them and relink the references manually on about 15 computers! :eek: I found this article in the MSDN knowledge base and tried the code to fixit, but it...

Hi, Does anyone know how can I open "Windows Explorer" to a particular folder from VBA? I want to make a button that accomplishes this. If you have any ideas or suggestions to links that will help me in this task, please respond. P.s. I searched the forums for a bit and didnt find anything...

Hi, I have a report that is based on a dynamic query. The query gets it's parameters from a unbounded form. I would like to get "descriptive" text field from my combo box into the report not the stored value in the combo box. The combobox has TypeID and TypeName columns and TypeID is the...

Hi, I want to automatically import an .xml file into a table that i have in my .mdb. Is this possible and if so, how do I do it? If you could point me in the right direction that would also be great. Thanx in advance...

Hi, I have a form that has been working for me without problems for a long time and now it has stopped working! When I try to open it, this pops up: Run-time error '2427': You entered an expression that has no value. The code that generates the error is in the Form_Current event and this...

How can i get a value from a snapshot query and put that value into a field in another table? The snapshot query is like this (qrySnapshot): DocID NewReference And the table has fields like this (tblDocs): DocID Reference. ... I want to press a button and through VBA put the (text) value...

Hi, I have a (.mdb) database and I want users to be able to choose when they enter the database whether they want to use/work with the database or whether they want to just browse through it without them being able to change (or destroy) anything. I need to put this feature in because people...

Hi all, I have a form in my .mdb that has several subforms that I control the visibility of by pushbuttons. The pushbuttons (and the visibility of my subforms) should be remembered in some way for every record so that when I go between records, the pushbuttons and visibility should change...

Hi I want to make my database more robust and user friendly by restricting the access my users have to various resources in my database. E.g. I do not want the users to be able to see the database window, no matter what. Also I would like to remove most of the options in the Microsoft Access...

I have the following problem: I use a filter in my form to filter continuous records and while the filter is on I want to be able to duplicate a record but Im having trouble with that. the following code is my filter and the error happens on the line: Me.Filter = strFilter When I try to...

Hi I have a .mdb FE running on a SQL server BE. When I run the following code I get the 3021 error: No current record in the line: rst.FindFirst ("DrawNo = '" & DrawNo & "'") Does anyone have advice for me. Do I have to convert the code to ADO to be able to do this or is there some workaround...