Search results

Hello, We have an access database (Back End) which is stored in a SharePoint Doucments store. We use this as a datasource for various PowerBI reports (which have inbuilt connectors for such a setup). We would like to add a Front End ACCDB to interface with the data, however, I can't see a way...

Hi all, I'm in a bizarre situation which has me scratching my head. UK based, I've just distributed a simple front-end database which allows users to enter Widget information (onto a SharePoint List). This works absolutely fine for all team members except one(!)... When this particular user...

Hi all, I recently asked how to Import CSV data (in the form of a string) into an Access Recordset. But now I need to do the reverse. I'm running an API request which returns a CSV string, and would like to save that to somewhere on the user's PC. I currently have no idea how to do this. I've...

Hi all, I have an API Get Request which returns a CSV string, what is the best way to interrogate that string? I'm looking to extract specific columns, or convert it into an access table? Sample string below. From googling I found the TransferText method, however this only appears to work for...

I have a table (tblSchedules) which contains any number of duplicate values, and I'm trying to write some SQL to delete all but the newest record (the one with the largest auto-ID). I thought I had it cracked, but I'm getting the error "Could not delete from specified tables". Can anyone see...

Hello, Sorry if this is a silly question. I am learning how to write API requests in VBA and have gotten quite far: the request sends and returns a correct response. eg: <?xml version='1.0'...

Hello, Excel Amateur here. I have table with columns: UserName, {Miscellaneous Details}, and the Country they live in (a 3 letter code like USA, ITA, THA). I would like to programmatically add an image of the national flag for these countries in an adjacent column, can anybody help? :) I've...

Hello all, Been a while, please help me remember how to do this :) I'm creating a weekly 'meal planner'. I have selected 7 food items at random (from a query). Now I just need to assign those items to 7 different fields (Monday-Sunday) in the MealPlans table. Basically like this...

Hello, I have code that prepares a calender appointment in Outlook (based on similar code for prewritten emails). I would like to check if the user actually clicked send, or if something stopped it. For emails there is mailitem.Sent, is there an equivalent for appointments...

Hello, Apologies as I'm sure this will have been asked before but I couldn't find anything on the search. I want to open a form as dialog to prevent users from going into anything else until they close the new form. However, I also need to move this form to a new record when it opens. Code...

Hi all, Can anyone explain to me how the Input Mask's work (field property within a table)? I'm trying to setup a table with Fields for a Username(txtUser) and Password (txtPwd), the latter of which I've setup with 'password' in it's Input Mask property. So all I see is a string of asterisks...

Hi All, I'm hoping someone can help me to understand some odd behaviour I've observed (Access 2010). I wanted a combo box with options: Basic, Intermediate, and Full, but I want to return 1,2 and 3 to the control source. Should be easy, I set these properties: Control Source: {Blank} Row...

Hi All, This is probably simpler than I realise but hard to explain (please bear with me). I have some code setup which sorts records of a continuous form alphabetically. The user clicks on a header label and it adds to the OrderBy property. See code below, it works fine, with one exception...

Hello all, I'm having an issue with some code designed to navigate a continuous form - it's your typical arrow key navvi, up goes up a record, right key tabs across, etc. All was working fine, when, inexplicably, the keycode for left stopped working. Here's the code: If KeyCode = 37 Then...

VBA Scripted Outlook Email with sent/cancelled checker, how do I stop Users Saving as a draft? Hi all, been a while since i logged in! I have some code that writes an email in Outlook, and returns true or false depending on whether the user sent the email (or clicked cancel). This is working...

Hi All, I am trying to create a form for users in MS Word (although any commonly accessible software would be fine) with the plan to import the data into my Access database. However I am not sure how to setup the Word Document or identify the correct controls from which to extract the data...

Hi All, Sorry if this is a dumb question, is it possible to use a select case statement in conjunction with a with statement? Specifically I am trying to test if the control sources of different subforms are null. I could do this easily with nested Ifs, but would prefer to use select...

Hi All, I've encountered a strange feature of Access VBA, which while isn't critical, is very annoying. So I'm typing in the code window for a form (doesn't matter what form, report, macro, or if its real code or just 'notes), but Access is deleting the spaces I type almost as soon as I...

Hi All, This is going to sound really pathetic and I'm sorry to even ask. But does anyone have any good examples of Access Charts and graphs? The thing is, I have never used Access for this function, always been much easier and simpler to export data into Excel and do all the number...

Hi All, I've been asked to put together a function that prints two different reports and up to two hyperlinked documents on our network (based on a selected combo box item). The idea is to save users from having to locate each report individually - Easy enough I thought, I just tell access...