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

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

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

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

Hi. I am not very familiar with using recordsets in VBA, but I think for this problem I am going to learn how. I have an append query that I want to run as part of a backup routine. I have designed an append query that uses a simple select query as the data source. I seem to have a problem with...

Not often I fix something but don't know why it fixed the problem. I have a table with 320,000 records. When I tried to construct a query with criteria to filter by BETWEEN dates, I only got records showing with the first date in the range. I was going nuts, when I finally decided to index the...

My workplace is moving to Skype for business for telephone calls. Initially it will be for internal communication, but the next stage will be to use Skype for VOIP calls for all phone communication. I would like to set up a command line to be able to click-to-call phone numbers directly from...

I have a combobox on a form that has many items to select from. I would like to set up navigation buttons that navigate through the combobox one item at a time. Am I right in thinking that this needs to be based on an "apply filter" command that selects the records based on the previous or...

I know this has probably been asked and answered several times, but I just don't seem to be able to get it right. I have a main form frmCallSheet, with a control Answered. This form has a subform control called sbfServiceContinuity, which contains a form frmServiceContinuity, which has a...

I don't know if there is already a solution posted for this one. I have upgraded to Access 2016, and for some reason now when trying to edit code in the VBA editor I have to fight some strange behaviour as I type. Often the options such as the ac... options just flash up and then disappear, and...

Hi all. I have a table that records user activities based on a public function that is called when logging in. The table shows a list of users who have logged in and logged out, but in some cases the user may have logged in and out several times in a day. I am looking to generate a list of...

I have a staff roster that I would like to add a feature that will allow the user to roster a member on a regular basis, either weekly, every 2 weeks, once every 4 weeks etc. as well as the option I have now for selecting the next roster date. I would like to have a combobox with options...

I would like to take this opportunity to convey my deepest thanks to the many contributors to this forum who have assisted me over the last three years with so many minor and major Access development problems and hurdles. I work for the Australian Red Cross, in administering a community program...

Hi. This seems like such an elementary question it is almost embarrassing, but I need to get it right in my mind. I sometimes need to add a new field into client's database, but I don't want to keep on just adding fields to an existing table. So I want to create a table with a new data field...

Hi. I want to be able to record the time that yes/no fields are clicked to a True state. I will have several of these in the form I am to build. How do I do this? I want the time fields visible but not editable, and to record the time when a yes/no field is clicked to indicate an event has...

Let me see if I can explain my problem. I have a crosstab query that displays information by month in columns as new data is added to the underlying table. For example, as may 2017 data is added, the crosstab query will create a column May-17, and as June data comes into being it creates that...

I have a rather complex expression in an unbound calculated field on a form. This started out much simpler than it is now, but as more and more conditions have been added to the expression it has now become too unwieldy to manage as an expression. I am thinking of converting it to a Select Case...