Recent content by merika

It was, something else that is.... just found out via somewhere else that it might have to do woth saving the form in view mode, not in design mode. Made a copy of the form, packaged again and now it works liek a charm :) It is however very strange in my eyes.... how come the form works well on...

I have finished the design of my DB and am ready to distribute it to my users. Everything seems to work fine and it installs great. Upon opening the appication, users are presented with a form that serves as the main menu. On the form there are 4 buttons: 1. To search for records 2. To enter...

So as mentioned... the accdr file is included in the msi now. It installs perfectly and opens correctly. The next problem comes when someone clicks on a link in the menu form. The following message pops up: The expression "On Click" you specified as the value of the property from the failed...

Hi Nige, Seems like it works again. Have no idea why the package contains the addcr file now when it didn´t do so earlier (maybe taking screenshots was simply enough :rolleyes: )

Hi all, Finally my DB is done, used the package solution to be able to isntall a front end on the end-users PC´s and worked fine. There was however a small update I needed to do on one form after installing it on 2 PC´s (needs to be on 20 pc´s). I updated the form and packaged everything again...

I´ve actually looked at that cruiseline example before and it gave me a good head start. The problem I ran into however is that I have over 150 different boats whom each visit 2 different sites per day (1 in the morning, 1 in the afternoon and they need to be listed seperately) on different...

This is the complete code I have now... Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long Const conJetDate = "\#mm\/dd\/yyyy\#" If Not IsNull(Me.txtStartDate) Then strWhere = strWhere & "([SailDate] >= " &...

Hi bob, Understand where you´re coming from. LEt me expalin a bit more. I´m creating a database with in it routes for various cruises. I have a table with all the sites they visit which is linked to the various boats. The itineraries are a maximum of 15 days with 2 site visits a day. The...

I´m having a search form with mutliple fields which is working great (implemented the search solution of Allen Browne) except for one part. I need to have one text box that searches 30 (!) columns of the attached query. No matter what I try in VBA, I can´t get it to work properly. I have no...

didn´t notice earlier.. thanks for pointing it out once again! :)

Hi Pat... Thanks for the suggestion of creating a sub-table but that will not solve my problem, I think. I will look into it though... as you neverk now :)

Thanks Terminator for the suggestion, i´m going to "struggle" with that and think it might be getting me there where I want to be :)

Hi all, I´m struggling with getting the right VBA code for a form I have in my DB. I have a form with over 40 fields on it. Depending on the number in one text field (called días) I need to show or hide a lot of other fields. For instance, if the number in "Días" is 4, 33 fields need to be...

Hi bosley, I was wondering if you ever fiugred out how to do this recurring calendar. I can´t seem to get my head around it and am struggling with setting it up correctly for my itinerary DB where every trip has a recurrence (and I know just entering all the date for a trip would not make any...

Hi Mark, It sure does make sense! Thanks so much for getting me out of my thinking game and see it a different way! I´ll get started on this and if I run into other issues, I´ll be sure to post back :) Think this is exactly what I needed to get started again... Just one thing though...