Search results

Finally I've got a solution, using Internet Transfer Control, to copy by ftp the remote database onto the local PC (the C drive in the example below), from where the data can be read into the local Access database for local use. Reference...

Thanks again HiTechCoach. As a work around I'm exploring the possibility of using the Internet Transfer Control to copy on demand the remote database file by ftp from the webserver to the local PC, from where tables in the copy can then be linked into our operations system in the normal way...

ThanksHiTechCoach. I'm finding it hard to believe this is so complex/unusual. Surely everyone who collects names/addresses from a hosted FrontPage website needs to get that data back from the webserver on to a local office system. Perhaps I'm just going about it in the wrong way? For the...

Thanks Wazz - that's good advice too. I think I'm going to need a touch more detail to be able to implement that - ODBC etc is new to me. Notably, in Admin/ODBC/'Microsoft Access Setup', when I try to 'Select' my remote Access database I hit problems. The ODBC dialog requires the remote...

Thanks for the suggestion, Galaxiom. I am looking for a solution that automatically maintains fresh data locally for my users. Surely if I deploy the ftp solution then my users will have to manage that themselves as a manual step - in my particular case that wouldn't be an optimal solution. I...

Can anyone steer me to the best way to link a table in an access database hosted on a remote server to a table in an access database on a local PC? A data access page on my website (created in FrontPage2003) is collecting names and addresses for mailings, now I need to harvest that data onto my...

I need to open the form at particular record called by another form so (1) open the form in design view, make the page margin changes, save it, close it (2) open the form from the other form at the required record and print it. That should work. I'll have a go tomorrow.

I have no trouble formatting this form for printing, except for this one issue, and there are benefits from keeping it as a form. Can anybody lead me to an understanding of why changing views in code causes a form to be unable to address its controls?

Thanks for your suggestion. Before I try the report alternative (a fair amount of work and no particular guarantee of success) I'm hoping someone will come up with the reason for this strange behaviour as a form.

My ACC2000 form has some controls that on the OnCurrent event are conditionally made invisible. I also need to adjust the page margins programmatically. In ACC2000 this must be done using PRTMIP which necessitates loading the form in design view (DoCmd.OpenForm frmMyForm, acDesign) setting the...

Thanks Chris. That looks like a good solution too, and needs no special function so would be neater.

Thanks Rural Guy, Allen Browne's funtion worked immediately for me - saved me a lot of hassle working it out for myself! A great help.

In ACC2000 on a PC set up for UK time/date format (DMY) how should you include a VB date variable in a SQL criteria statement? I'm finding that when dteTestDate is 12May it is evaluated in "SELECT * FROM tblMyTable WHERE SourceDate = " & #dteTestDate# & ";" as 05Dec. I've now learned that...

GolferGuy: no. rolaaus: occurs in design view, not code.

I have a strange bug in Acc2000. For any main form with a subform, when I am designing the subform within the main form and I alter and save the datasource of the subform, the datasource of the main form mysteriously changes to the same datasource. :eek: Drives me nutz. Has anyone else seen...

Hi lagbolt Many thanks for your suggestion, which is a very good one. It is somewhat along the lines of the solution I've been exploring, except I need the combo box source to be live data. I'm finding I can achieve the functionality I need (described in my reply to Bob above) by (1) on the...

Hi Bob This is a 'paged' form with an array of controls displaying 25 records each time, each linked to 2-3 tables. It is bound to a table that often needs 2-3 screenfuls to display all the records. The user clicks Next/Previous buttons to review the whole set page by page, like a Google...

I understand that Jet 4 has a 2048 limit on the number of TableIDs which if exceeded leads to this error. My form uses 1 bound table, 2 recordsets in code, 1 clone (opened, closed and nothinged in 10 lines) plus a 5 x25 array of combo boxes whose sources are 14 x25 tables (as part of queries)...

My objective is to display rows of data on a form in the 'page' format, with each 'page' within the form showing a fixed number of rows, just like a Google seach page for example (or this forum). (If anyone has seen this done successfully in Access then please let me know!) Mostly I need to...

On MyForm I have a group of controls that are populated programmatically from MyQuery which includes a criterion using one of the forms' controls: ... WHERE MyField = Forms![MyForm]![MyControl] The recordset for the controls that are populated programmatically is loaded on the form's OnLoad...