ms access query

Hello. I am using the latest driver (Simba Spark ODBC) to connect to several vNext tables. The connection was working fine until ..approx a week ago. Nothing has changed on the PC as well as on the system data / table side. I am receiving a Reserve Error - 7711. I have tried to refresh / relink...

Hi Community - is there anyway i can use the following code to connect to a MS Access DB stored on sharepoint instead of my local machine or a shared drive? I ran into some issues with permissions, and found that this DB would need to be stored on sharepoint- any guidance? Public Sub...

Hi Community, Hoping you can assist with helping me understand what i'm doing wrong with code I found from another post for querying an Microsoft Access Database to retrieve records WHERE a Column value = GetUserName(). When i run the code I either get an error, OR i don't get an error and it...

Hi im hoping someone can help me with this because i am really struggling.. I am having issue with ".CommandText = Array( _ "SELECT * FROM Consolidated WHERE [Start Date]> '2019-01-01 00:00:00'")" it seems to be working fine if i do the criteria on brand or anything else.. however it...

Hello I have an Access Db to export a query and create a chart based in worksheet ranges (B2 to last value down) and (C2 to last value down). My command button my code creates a chart with primary and secondary axes values. This is my code working well: Sub cmdTransfer_Click() Dim sExcelWB As...

Hi all I am new in this grout i have a query regarding the sub report. i have an parent report in which sub report is placed. when i manually open the parent report then sub report binds with one record in multi pal times like record 1 record 1 record 1 ..... , and when i manually open the...

I have been hunting trying to find the solution an I have tracked down the problem to be with the joins in my query but it keeps returning syntax errors when I try to change it. I need the table classes to be the main table for the query. I need to see all of those records and I just want the...

Hi all, i have a database which is getting updated 6000 records every day which calculates me the Turn around time. the data is given below Priorits SDate ODate Diff Emp Supervisor 1-ASAP 01-Nov-11 01-Nov-11 0.00 A,b team A 1-ASAP 02-Nov-11 01-Nov-11 0.00 b,a Team B 1-ASAP 04-Nov-11...

I am preparing a report for occupancy based on room rate classification. We have three rate classifications, depending on long-term, short-term, or Penthouse: Tenant, Transient, or Penthouse. The first two may occupy the type of room, but the third is only in the condos. The "Building...

<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td><code></code> I have been using a ms access database with my online booking application. My host upgraded me to a 64 bit server and ms access do not for my asp.net app. anymore. I upgraded to MS SQL and now my ms access query will not...