Search results

Hi there There is a report I need to create and I don't even know where to start. :o I tried creating a query, but am not getting that right. Here is what I want to do: I have a Due Date and a Completed Date field. I want to know the number of instances (records) where the...

Ok, spoke too soon. I removed this line and now the button works. Problem is - it puts the link in my hyperlink field, but when i click on the hyperlink, it does nothing. It doesn't go to the folder.

I have just tried this code too, and am stuck! I get an error that points to the line .Filters.Add "All Files", "*.*" Not sure what to do.

Hi ajetrumpet - sorry to sound dense, but does this link to a specific address? What I am looking to do is create a Browse button so that the user can select a folder which will be stored in the hyperlink field. They can then click on this when they next need to look up the documents.

Thank you so much. It worked! I really should have seen this!

What do you mean by application.followhyperlink method? I would basically like the user to select a folder, or be able to create a folder. The folders will all be in a specific place and they would need to create/select a sub folder in that list.

Hi there I have downloaded Stephen Leban's Calendar and have got it to work beautifully! Only one small issue, my date field is on the edge of the form (the right hand edge) and the calendar pops up to the right of the field, so it is almost all off the screen. Is there a way to get the...

I created the form using the wizard initially and then made a number of changes to it. So the form is all set up. Do i need to create a new form to use for editing and searching? Can I search on more than one field - I mean, search on this field, or that field, or that field, not lots of...

Here's what I am trying to do - I have a hyperlink field. Next to the field I want to put a command button. When the user clicks on this it will open explorer (or similar) and the user can browse to the correct folder, then select it. And this will be stored in the hyperlink field. How on...

Hi there I put the combo in the header and I can look up a value from the list, but it doesn't have any effect on the form. It still stays on the record that it opened on. Also, I have an input mask in the table on this search field. In the lookup box, the formatting from the input mask has...

Hi there I have tried searching this forum, but I must be searching on the wrong words or something and I can't find what I am looking for. I would like to have my main form open without any records showing, and then the user can type in information in one of the fields and click on search...

Just a further clarification on my post above - the Due Date is not calculated, it is given to us. So this is a value that I have and I need the value for the new field to be calculated, but there must be the option to override the calculation.

Thank you so much guys. Unfortunately the forum won't allow me to give you more rep points, but you do deserve them!

Hi there I have a field on the form where I would like to have a default value which is the Due_Date minus 1 working day. What I have managed so far is: =([Due_Date]-1) But two problems, first - this is not working days (i.e. weekdays) and secondly - the default value doesn't work. On the...

Oh dear, I can't remember the names. I guess I could just delete all the buttons? Do I delete everything? Or do I leave the bit that says Option Compare Database End Sub If I delete a button, why doesn't the code also get deleted? I don't understand how this works. Thanks for the help so far!

Thank you guys. twoplustwo - what I mean is that I can't add records, I can't change records. Right now it is showing one record instead of the 5 I have. Guus2005 - I have opened the code window, but I don't know what to look for or what to delete. I have not experience using VB, so I am lost! :o

Hi there I have been creating a form and I have added some buttons to it, but have not at this stage programmed them (still trying to figure out how). Anyway, everytime I change something on the form, like adding a button, the form stops working. Last time there was a bit of code left after I...

Thanks! Do I then just put buttons instead of using the switchboard function?

Hi there I want to know if it is possible to do this, and if so, how. I want to have a report appear on the switchboard when the programme is first opened. Please see attached for an idea of what I mean. Thanks!

Thankfully a friend found the problem! I had previously tried to write a bit of code for a button on the form and had not deleted all of it properly. That was what was causing the combo box problems!