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

This works perfectly :) Thanks ebs17, I hadn't considered the similarity between .text and .csv

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

It could be... I would need to do it programatically and bearing in mind this could be on any number of Users PC's, it seemed like the more onerous option, but I am open to all ideas, this is new to me :)

Thanks CJ I can see what you're getting at with the Split function. Unfortunately I'm getting a "Subscript out of Range" error :( something to do with their being multiple rows and line breaks (i think) time to hit up google again I think :D

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

Thanks both, Arnel I couldn't get your solution to work though I can see what it's trying to do. ebs your first solution worked well. Many thanks :)

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

May have solved it myself, adding this to the bottom of my current code: 'Parse response and do stuff: extract token value and set as variable 'EG how to do this: 'GetKronosKey = the value of <token> 'Define the variables needed to create our xml document Dim xDoc As...

Thanks theDBguy, do you have any examples/know any resources I can look into? I've been googling a while but I'm afraid I don't even know what to search for :'D

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

Thanks everyone for an amazing response. I've sorted it now using @MajP's first solution. Truth is I wasn't sure whether to update it on the form or direct to the table, but I checked and both ways work great :) @Gemma you're correct it may be possible there are only 4 rows etc, but should be...

Sorry I'm being real dumb... How do I extract the nth record from the query (to append it to a specific field in another record)? Can it be done in VBA? I could do it with 7 seperate SQL queries but that seems like a bad approach. Thanks :D

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

I think you may have meant that the other way around(?) but thank you it works! Private Sub Form_Load() Me!sApprovalReviews2.SetFocus DoCmd.GoToRecord , , acNewRec End Sub

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