Search results

This can be done of course but are you sure you really want to set up the system that way? It seemed ok to me right up to the point where you stated that the BE structure would not be identical each time. If you switch the BE tables what happens to a form that references a field that no longer...

After going through the code in the link and putting together some other bits and pieces I found the simplest way to do this is below: Set dbs = DBEngine(0).OpenDatabase(PathToMyFE) Set tdf = dbs.CreateTableDef("Table1") tdf.Connect = ";Database=" & PathToMyBE tdf.SourceTableName =...

Thanks, I should be albe to get what I need out of there... Bob has kindly posted the utility on his website: http://www.btabdevelopment.com/main/AccessTools/tabid/78/Default.aspx Tom

Hi, I am in the process of adding a couple of extra bits to Bob Larsons extremely useful FE auto update utility and have got a bit stuck on something relatively simple but I can't find any good examples for the code I need because strictly speaking it's bad practise to dymamically link tables I...

Hi, I thought i'd post this example because I recently had to do this for a project but most of the MS documentation relates to the EightBall webservice on the now defunct GotDotNet site. I'm not sure if it will work or not unless you download the Web Services 2.0 toolkit which includes the...

Hi, For a project i'm working on I need to get data from a real time interface which uses web services and returns XML. I have managed to connect to the web service and get a DOM NodeList but I am now struggling to get the data into Access somehow. I was hoping i'd be able to Save the Node list...

Hi, For a project i'm working on I need to take data from a RTI every few minutes or so. The data then needs a bit of processing before it can be posted to another table which users will be constantly querying. I'm thinking about creating a second back end just to handle the "Real Time" table...

I'm sorry but that is just RIDICULOUS!!! I've just been reading up online and I haven't seen a single developer who seems to be in favour of ditching ULS. One official Access blog got bombarded with protests as early as 1995 but it seems like they didn't listen. Fair enough - change the name...

Does anyone know why A2007 has completely removed the User Level Security (ULS) from it's new DB format? It seems crazy not just for security but how easy it is to create user-specific functions (audit trail) etc. with Application.CurrentUser I know it will remain the same for <=2003 MDE's...

IMHO the treeview is not for the faint-hearted... wouldn't a simpler solution be to store a sequence number against each step, task etc. so re-organising them is just a matter of changing the numbers? E.G. If you have Seq# Step 1 A 2 B 3 C and you want the user to be...

This should work for you... It uses DAO recordsets which is a bit dated but most people find it easier to start with than ADO (which most people will probably recommend once you get the hang of it!) Dim dbs As DAO.Database Dim rst As DAO.Recordset set dbs = application.currentDB set rst =...

Hi, I would just like some general opinions about progressing from developing in Access/VBA to developing in VB.net? Basically I am a self taught developer. I started learning VBA by recording Macros in Excel and looking up the code afterwards. I then started building more and more complex DBs...

The example above from microsoft works except that the print event code is slightly wrong. It should be Sub ReportHeader3_Print (Cancel As Integer, PrintCount As Integer) Dim dbs As Database, rst As Recordset Set dbs = CurrentDB() Set rst =...

Ah! Although it's a bit of a pain you'll be much better off eventually in Outlook. Our company ditched outlook for Groupwise cause it was cheaper but there is so much stuff missing in GW that I would use if we had outlook. Glad you got it sorted. Tom

Hi, Yeah I cracked this one and use GW address book control in almost all my DB's now. Sorry about the late reply but i've been away from work for a bit. If you still need it get back to me and i'll sort you out some examples. HTH, Tom

That's amazing... Working in an evironment where an end user was told to click the mouse on a button last week and she physically picked the mouse up and touched it on the screen this will make my life a lot easier! Thanks, Tom

Someone has just posted something in the sample DB's section which may do what you want... Haven't tried it but have seen something similar before. HTH Tom

Hi, I'm trying to delete some records out of a table. I have a query that acts as a filter and is linked to two fields of the table that I want to delete from. I have put the * field from the table in the query and set the "Unique Values" property to "Yes". Access tells me "You cannot delete...

Sorry Seth can't upload due to size plus the fact that I work for local government makes it a tad confidential! R G that is useful but I don't think that is my problem because it would be consistent with forms that had the same data, and it isn't. I have stuck a SaveRec command after each...

Hi, I have a DB that is basically a big electronic form. Each table is a section of the form and the main central table stores the ID's from the other tables. Most of the relationships are one to one but without referential integrity because sometimes sections need to be skipped. It's been...