Search results

I just seem to be going around in circles trying to figure out this update query design for something I thought was simple. I want to copy a few fields (surname, firstname, DOB) to the current record from an older record the user has identified with a button on a continuous form. I know the new...

We enter a number of addresses in our database (transcribed from paper forms) and I was wanting to speed up/increase accuracy of entry for our users. Has anyone successfully incorporated the Google Maps (Places) Autocomplete API into their database? It would be great if the users could start...

I am hoping for some advice about changing the set up of a database to follow better design rules and habits. The database I am working on has slowly grown and needs some changes which is a good time to look at the basic structure. The current requirement is that we receive a number of...

I'm chasing how best to store the field names from all "true" fields from a table in an array (recordset? SQL?) and feedback of whether I am going about this correctly. We audit documents and each document can have any number of issues from a defined issues list (although this list grows over...

I have 2 Web Browser controls on the one form (webLeft and webRight) which both have a .pdf loaded. I am hoping to link the scrolling between them so that if I mouse or keyboard scroll in one the other scrolls by the same amount. Is this even possible in Access for Office 365? There appears...

I am trying to get a running total of documents we process during the week, displayed in an unbound text box with a dcount as the value. I have managed to get the daily count using: =DCount("*","[tblDocumentLog]","Int([DateCreated])= #" & Date() & "#") But I am struggling with the correct...

I am trying to figure out the best way to design a table and form to achieve a result. I have 3 fields which I need users to enter: [Facility type] - one of 5 options: hospital, racf, community service, GP and Other. I have a set list for the first 3 options which I want to restrict users to...

I am trying to piece together the best practice for lookups and have read the basics but have some questions on the finer points of setting it up. I have seen many times: http://access.mvps.org/access/lookupfields.htm and I am trying to avoid table-level lookups. I have table with a list of...

I am attempting to create a mail merge database which can create printable labels and need to increase the number of generated labels of certain types based on user input. I have a main form which has some fields which appear on every label (name and DOB) then I have created a subform which...

I am trying to allow users to drag and drop an Outlook email on to a form and have it save the .msg to a destination folder and store the information in a table. I have read the tutorials and achieved this for regular files (drag and drop via explorer) using a ListView control but Outlook...

I am seeking some advice on how best to set up some cascading combo boxes (or if this is exactly what I need to start with). (I have read the link to Cascading combo boxes examples but my needs go beyond those examples). The scenario - I have a form used for user entry which I want to guide...

Hi All I'm a google search hacker when it comes to Access programming and am seeking some guidance about how best to achieve a goal so I can research in the right direction. I have a database with a main table (DocumentList) and a primary key DocID. This is linked to a second table (SiteList)...