Search results

If your tables are all the same structure and you want them all together, you'd be much better off creating a UNION query, because the query results will automatically contain the latest data whenever it is run. But your problem here is really caused by the design of the database - it...

I've got an Access application that runs from a popup form and launches some pop-up reports - this all works fine, but I can't work out how to offer the user a print option for the previewed reports. The application needs to run in both Access 2003 and 2007, so the custom toolbar approach won't...

I'm not sure - because of the way Access works, it's quite difficult to shut a determined user completely out - but here's a link that might have some useful ideas in it: http://www.access-programmers.co.uk/forums/showthread.php?t=95390

Ah, wait a moment, I just re-read your original post and I think I misunderstood your question - are you talking about making your whole application expire after a set time (i.e. to control software licensing)?

OK, so the first thing you need to do is to set up your database so that it controls who can log in - there's an example in the samples database forum that might get you started on that - here: http://www.access-programmers.co.uk/forums/showthread.php?t=170781

Have you tried creating a new empty database and importing the table into it?

What kind of user account structure, if any, do you currently have in place?

If the data is coming out of an EDI communications package, it ought to be structurally fairly consistent - although there will probably be unpopulated columns for some companies, depending on their own data.

Scambaiting can be a lot of fun - I've toyed with it myself in the past - such as this example which I documented on the SDMB: http://boards.straightdope.com/sdmb/showthread.php?t=242804 I'm not sure I'd take it quite as far as some of the 419eater folks are prepared to go though - especially...

Yeah, it's almost as if they were trying to help. OK, here's the answer you need: Try harder at getting MySQL to work- other people manage to use it OK, so it can't be rocket science. You're not likely to find a database solution that is as robust and capable, but simpler to set up and...

I've worked with EDI applications in a number of contexts - both generating outgoing files and parsing incoming ones, but it sounds to me like your file is coming out of an application that translates the highly-structured raw EDI message into a flat file table - am I right?

OK, in the immediate window (the separate bottom section of the VB editor screen, maybe), try typing: ? wpath this should show you the value held in the wpath variable (you might alternatively be able to see what it is just by hovering your mouse cursor over the name of the variable in your...

Is there any field (or combination thereof) in the original text file table that uniquely identifies each record?

You definitely have a normalzation issue. Instead of storing (say) three check values as three fields, a better way is to store them as three records (each with check name and check value) in a child table, with a key to link to the parent record. The same holds true for nearly all of your...

There shouldn't be any need to look up a value, store it, then use it for calculation later - you can do this all in one go in a query...

Just wanted to mention that this will only work in an ordinary form layout - if you conditionally show/hide/enable/disable fields in a continuous or datasheet form, the whole column will be affected by whatever the current record is doing.

You don't need quotes around acFormatTXT - it's an access constant.

I don't know if this helps at all, but I had to do a similar thing to this in an application I'm working on at the moment. I stored my email body templates in a memo field in a table, with line breaks etc, and just put placeholders where I wanted the data inserted, so the template text might...

I've got a datasheet subform that can be filtered in a variety of different ways (the user chooses predefined filter configurations from a combo list I have provided). Only problem is, the users can (quite rightly) edit the content of the records so that they no longer fall within the filter...

Also, if anything changes in the underlying data or criteria etc in the query, your next run will still be numbered, but the results will not be consistent with the first run.