Search results

I can't solve this one: I have Private sub Openfile_Click() dig G as Long Dim strDocpath as string strdocpath = "C:\Users\MvP\Documents\manual.pdf" G = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & strDocPath, vbNormalFocus) End Sub The strDocpath is correct, but the file won't...

Thank you for your reply. It convinced me I should not go for internal attachments. The Pat Hartman reply made clear I should also avoid hyperlinks. Thus, I've been looking around a bit, and I think I'll go for a third solution, building on the second one: I copy the selected file to a...

Hi, I want to add attachments. I want advice before getting started. I figure I could do one of two things: - use attachments in a table, storing the attachment in the db; - leave the attachments outside the db and hyperlink to it. The first solution is easy, but I prefer the second one...

Okay, I get that and I'll look into it. Say however for now I want to distribute a fe_version without users. 1. Is getting rid of the fe_table and just run the risk that people will do a simultaneous search preferable to distributing a version with the fe_table? 2. I figured a bonus of the...

I'll try to put it clearer: originally, I made a db for personal use. It contains bibliographic references. In my original db I added a search form, where I could select all the works of a certain author, ... Because I don't always want to print all the works of a certain author, I added a...

Because I have users do a query in the FE table, where they can mark the results they want to print. If I have users mark the results in the BE table, I get conflicts: if two users do a search in the same table at the same time, and they both mark results they want to print, then they get each...

I split my database. In the BE I have a table Sourcestab. In the FE I used a make table query to create Sourcestab_fe. I have a form to add records to Sourcestab (BE). I also have a search form searching through Sourcestab_fe. On opening the search form, I want to update Sourcestab_fe (add...

I ended up going with If Not [CurrentProject].[IsTrusted] Then 'first Msgbox '(indicating that the database should first be trusted and how this can be done) 'next Close database. If [CurrentProject].[IsTrusted] then OpenForm. It is essentially what was suggested, but it's not ideal...

I'm not sure I get your edit. If I call the macro to close the database instead of opening the notification form, then how can I get the database to be trusted, if it is not trusted yet?

I have what I assume to be a newbie question: I'm creating a database that will soon be used by some others. In order to prevent unwanted changes in the structure of the database, I open up homeform with the following code upon opening the database: Dim i As Integer For i = 1 To...

Thank you. I 've tried that, but I get an error code 32521: "you cannot change the value of this property in the event OnPaint". (freely translated). Should I change anything?

So they are linked, the CanShrink is set to yes, the code is as mentioned above and it is in Private Sub Details_Format(Cancel As Integer, FormatCount As Integer), but still, the labels show when the text is empty. I just found out though that they disappear in print preview, but not in what I...

Thank you for the reply. Since I'm not sure whether the label and text box are linked, and how to hide the text box, I first tried the second solution. It doesn't do the trick. So, I'd like to know: - how do I know for sure whether the label and text box are linked (the label appeared when I...

Hi, I'm trying to hide labels on a report when text boxes are empty. The labels and text boxes are in the details section. I use: Me.labelName.Visible = Not (IsNull(Me.txtName)) Me.labelStreet.Visible = Not (IsNull(Me.txtStreet)) ... I put the in the OnFormat of the Details section...

Thank you! Thank you for the suggestion. It works just fine now. And it is about ten times as simple as what I had been messing around with!! Sometimes one just has to know the right functions... Here's the code: Dim f As Form Dim intCounter As Integer Dim strlist As String Set f =...

Is this really unsolvable? I still haven't figured this one out. Is it really not possible?

Wish I could Thanks for the reply and the suggestion. However, it will not do for me. The reason is that some people have the same emailaddress, but I don't always know which people. This is also why the listbox has the names of the people, and not their emailaddresses. Any other suggestions?

I have no education in VBA. I developped some notions of it, though. Usually, I can solve the problems in my database with some copy and paste from this excellent forum. However, this time I don't manage. Here's what I'm trying to do: I have a form linked to a table that contains groups of...

I'm quite positive there's a more efficient way to do it, but with my limited VBA knowledge, this ended up working for me (Querytwoform is a Form with Query2 as a source; it is invisible when it's opened; MultiEmailForm is a form with the table with emailgroups as source): Sub MaakQuery2() Dim...

I still haven't been able to figure it out! Any suggestions are still very much appreciated. I'll keep you posted once I find a solution.