Search results

Thanks for the reply Bob, I did not find that "little black handle" you mentioned, but instead I used the combo box on the Property Sheet in report design view to select the label and change its visible property to No. So problem solved!

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...

Yeah I did a search on this, found a similar piece of advice and it seems to be working fine. Thanks for the help!

Thanks for the quick replies! Is sample code for this available somewhere? Go Magpies!

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!

Thanks for the reply! 1. I pinged the server and that works like a charm. 2. This particlar user has a valid account in sql DB. This problem is only with this one user. 3. I set up the system so that all users log on using windows authentication. This works for all of my users and I have...

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...

My developement computer has Access 2003 sp1 on it but some of my users have Access 2003 without the service pack. This might be the source of the problem but I would still be able to release my application without having to rely on the users to use the exact same version of access as i do. The...

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...

Great question, exactly what I need aswell. Hope someone answers this since I havent found threads that deal with all these issues.

Not very hard. I continued to search for a bit after i posted the question and found my answer just minutes after I posted ;) Thanx anyway.

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...

I want to import the document from code only so the user will not have to be involved in the process. Other than just pressing a button to import the data. I will post the solution when i'm done. But I'm swamped at the moment so it will take some time.

Thanx maxmangion it works great! I had however found a workaround that used the underlying recordsource. I put this into the control source property of the textbox and it worked fine. =IIf(IsNull(Forms!pfrmReportCustomer!ComboType);"";[Type]) But I like your solution better so I'll use it...

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...

This form does not work at all now. I get this same error even if i remove the whole form_current event. then the problem occurs just somewere else when i move between records. This problem occurred after I moved the whole database (Sql server 2000 backend Access 2003 frontend(.mdb)) to a new...

When you open the form, open it as read only. the command (in VBA) is something like this: DoCmd.OpenForm "FromName", , , acReadOnly