Search results

Hi all - does anyone know how to use a Google sheet as a data source for a local accdb?

Hi All In code I have a recordset rsOrders which includes the field rsOrders!orderID. I need to generate a report for each value of rsOrders!orderID, and then save that report as a PDF with date and the rsOrders!orderID value appended to the filename. So if rsOrders has 15 records I end up with...

Hi All What do I do with this Dim startdate As Date startdate = InputBox("Please enter the start date:") DoCmd.OpenReport "rpt_OrdersAnalysis5", acViewPreview, , "[InvoiceDate] > #" & startdate & "#"to get access to accept that startdate has been entered in UK format? I've checked that...

Hi All I have a report with a textbox in the detail section that has cangrow = true. The detail section also has two vertical lines, which I need to lengthen as necessary to match the textbox height. I've tried searching for this online and in this forum, but can't seem to find the method -...

Hi All I thought I knew how to use Count/Select distinct, but apparently not! I have this: SELECT DISTINCT Count([Order #]) AS [CountOfOrder #], Sum([qty]*[Item's Price]) AS [Value], OrderDate FROM tbl_orders GROUP BY OrderDate; The query runs, but the value shown in the 1st column...

Hi All I have been using the 'SearchInQueryDefs2' code from Guus2005 in the Code Repository, and it's excellent - thank you Guus2005 :) I was hoping to use it to help me amend some joins, because I'm replacing some text key fields with numeric key fields. I can use the 'SearchInQueryDefs2'...

Hi All We've had a few cases recently where a relationship (with referential integrity) between two tables has been broken by access. I think it happens when a record has been corrupted (I'm addressing this issue!). Is there a way to check with code whether all the required relationships are...

Hi All I have written the procedure below to lock/unlock all the fields on a form, and it all works perfectly where the form is open in datasheet view, but when the form is open in continuous form view I get "Object doesn't support this property or method" on line 110/140. I'm guessing the...

Hello, We've got a table that is now obsolete and we want to replace all occurrences of it's name in all tables, queries and reports etc in the database with that of a different table. Is there any decent tool out there which can help do this instead of a manual change? Many thanks, Les

Hi All I have a table [tblStaff] with a numerical key 'staffID' and a text field 'staffName', and I have a table [tblSickness] with that joins to [tblStaff] on 'staffID'. There are a lot of reports, and functions, that use the data in [tblStaff] and the related data in [tblSickness]. Would it...

Hi All I have a complex access2010 accdb in which the key field in the 3 main tables are text fields (e.g. staff_name). I understand that numerical keys are preferable (quite apart from the problem of needing to have two John Smiths!), so I intend to add new numerical keys - probably with data...

Hi All We have a split access2010 application in which the BE is 1.6Gb compacted. It reached 1.8Gb recently, then I compacted it and it returned to 1.6Gb-ish, but some of the FE functionality then virtually ceased to run:eek:. Some (very stressful:banghead:) hours later I discovered that some...

Hi All I have a query which runs fine until I set a criteria (of True) in the field chase_it: prevwd([practice_bacs_submission_date])<Date() So without the criteria, I have SELECT prevwd([practice_bacs_submission_date])<Date() AS chase_it, practice_bacs.practice_bacs_submission_date FROM...

Does anyone know if there is a good replacement for Speed Ferret? At http://www.databasecreations.com/prod_speedferret.htm I gather that "EFFECTIVE JANUARY 1, 2011 BLACK MOSHANNON SYSTEMS HAS DISCONTINUED THE SPEED FERRET PRODUCT." Pity - it sounded great:(

Hi All I'm no expert, but I think I've found a bug in access's query builder:confused: I have a query with 4 rows of criteria, with the same value in 3 of the fields (these 4 criterion must be satisfies in every case), and varying values in values on one row only in 4 other fields: so the 3...

Hi All I have a form frm_GlobalSettings with a combobox cmbDescription that finds a record based on the value selected. The row source type for cmbDescription is Table/query, and the row source is a select statement on the form's underlying table. I want the user to be able to use...

Hi All We have an access routine that creates and populates an excel workbook, and adds lots of validation - typically: 1220 With objSheet.range("AM9:AM" & lngRowCount - 2).Offset(0, ColOffset).Validation 1230 .Add type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop...

Hi All I have a report that has the query below as its data source. The query runs fine on its own, but when I try to run the report I get: "Multi-level GROUP BY clause is not allowed in a subquery". How can it be that this is allowed when running the query but not when running the report? If...

Hi All I have written a procedure into my error handling that writes all the error details to a table, so that I can audit/fix the errors that occur. I have a form frmErrors that displays the unfixed errors in continuous form view, with a button in the detail section that uses DoCmd.OpenModule...

Hi All We have a split A2010 accdb, and the backend is now 1.8Gb so I need to do something :eek: If I put each of the 4 main tables in 4 separate backend accdbs, will the fact that the frontend then needs to link to 4 accdbs in some way impact on performance? Another possibility (given that...