Search results

Hi. I will be needing to migrate an important Access database from a Citrix based intranet environment to a Cloud environment. What is the issue is that I have a VBScript file that performs a verification of version and copies the front end to a unique user's folder on their desktop. As the new...

Ok. So if I wanted the colour to "stick" on saving and re-opening, how should I write the code?

Thanks for the comment. That's not necessary, but I might look at that later. There are quite a few fields that this is being applied to so the programming for that might be a bit too much for now.

I tried the RGB designations instead of Hexadecimal, plus I added the Me.Combo0 as you indicated and that fixed it. Thanks.

Hello. I have been having trouble accomplishing what I thought would be a fairly simple task. I have a form with a combobox, which I want to be able to change the forecolor of on double-click. So if it is black, doubleclick would turn the font red and vice versa. This is the code I have for it...

Yes, that is true if there is a large user base with many users messaging each other. In the situation where I will be using this solution I do not anticipate that. For one thing most of the users are volunteers who have lower level access to the system. For them I would simply make the "Open...

I have done it! I used the OnTimer method to call a form which pops up based on whether there are any unread (checkbox True/False) messages specific to the user (TempVars set on login). Everything else is pretty simple with a messages table, users table and straightforward development features...

Yes, that sounds like it would work. I actually used an OnLoad event to play a practical joke on a colleague one time that used an If statement to reference his username and launch a form. I could use the OnTimer event to launch a message form in a similar fashion. Thanks.

Hi all. I have a database that runs on an intranet across the state, and there are times when it would be really handy to send messages to specific users. How would I go about setting this up. I imaging that a form with some VBA code referencing a specific username would be required. Is...

Hi. I have some data entry forms which I need to apply some mandatory fields for and manage them so that it is both user friendly and prevents missing data or errors. I want to be able to highlight fields that are mandatory, as well as notifications when trying to exit a client without...

I am having a frustrating time trying to work out what is going on here. I have tried to create a hyperlink on a button on a form with an address in on SharePoint. I have created dozens of hyperlinks, all with no problem, but for some reason this one doesn't work in Access. Strangely, if I paste...

Ah! Actually it works. I just needed to add a space to the last And " (I think!) Anyway it words now. Thanks heaps everyone!

Ok, I think I'm close. Maybe just a syntax error. This is now my code: Private Sub cmdFilterMulti_Click() Dim strWhere As String Dim lngLen As Long If Len(Me!cboFilterCategory & vbNullString) > 0 Then strWhere = strWhere & Me!cboFilterCategory & " = True And " End If...

Thanks Paul, I'll try that.

Yes, I have that code example but I don't really "get" it as far as how to incorporate all of the criteria. I do know another way to do it, which is not to use the combobox to select the weekday fields, but to display them as checkboxes and build the Where in detail manually using multiple "if"...

Ok, I have had an initial try at this. Obviously I am way off the mark as far as getting the coding right :o. I can write some VBA but I am still learning, so some patient guidance is gratefully received. Each of the filters works fine on their own, but it's concatenating and building the...

I see. Yes that makes sense. I'll have a go at that and see how it works. Cheers.

I want to set up a multi-field filter based on three combobox field selections. I can do this normally, but this one is a bit differend. Two of the fields are based on selecting True/False fields with names corresponding to the combobox selection, with the criteria as "True", as in the...

Hello. I know that there is an option to set the navigation bar as visible or not as a general option, but is there a way to have Access open with navigation bar accessible or not depending on an If statement on a login form? I would like to set up access to open with the navigation bar visible...

Thanks for all the input guys, but in this case the solution was too simple. I misspelt the query name in the command line! I was wondering why I didn't get an error. :) I have learned quite a bit though by reading your replies, so this wasn't a wasted question. Cheers!