Search results

Which icon are you talking about? One representing a specific file, or the Excel shortcut icon on your desktop or elsewhere? Either way, I don't think it's possible - the icons you see for files and programs are set by the file association - so changing it for one would change it for all other...

I worked for/with a developer who insisted on doing it this way - in fact, nearly all of the tables had the same structure, including every concievable field (i.e. full address fields and product attribute fields in every invoice line, etc). In spite of it being done for reasons of...

Yes, or "I've decided to drill a hole in my head, will a battery powered drill be OK?".

I agree - I'm guessing that 'delete' means in this context 'do not show in the results'. The big danger with anything like this is that as the table contents change over time the items included in or excluded from the list will probably be different each time.

My bet is fair division of work between two teams or individuals. In which case... what happens when a third team/individual enters the scene?

I think the way to do this is: Find some way of consecutively numbering the results in a query - such as this one (that I haven't tried): http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20492559.html Run another query based on the results of the one that imposes the...

agreed, it should create a continuous sequence in the table, in most cases if you add it to a populated table (although I bet there are still some exotic circumstances in which it might fail). But still, there's no way to guarantee that the autonumber will apply itself to the table in a way...

Dunno - there's no guarantee that an autonumber will yield a continuous sequence, or that the sequence will run in the order you want to present your query results - in either case, you could then end up removing multiple consecutive rows from the query results and leaving other sets of...

Copying the query object to create a new query named the way you want it sounds like it should work, but you run the risk of filling up your database with multiple copies of the query. Your code can take this into account, deleting the copied object after it has been used, but if something...

If C (or ++ or #) seems a bit daunting to start with, you could try Delphi - it's very similar to Visual Basic in terms of the form design and coding interface - the undelying language is Object Pascal - which could be described as C-like in its structure, but Basic-like in its command set.

SendObject sends an object from within your database (a named table or query) - you're trying to get it to send a named file - it can't do that. If you want to export the file with a specific name, you could use DoCmd.OutputTo to create it somewhere in the filesystem, then attach it to an email...

Is the installer placing the FE on the local hard drive, or in some shared network location? (reason for asking: is it possible that despite separate install processes, they're all running the same copy of the front end?)

Does none of the event code work? If so, you need to set the location of the file as 'trusted' - details here: http://office.microsoft.com/en-us/access/HA100319991033.aspx

Are you trying to do this from within Access? - I doubt that would work. Are you able to append all rows but that one into a fresh copy of the structure?

I've never heard of weak entities either (not that I'm any kind of expert). Looks like it's something that depends entirely on its foreign key to relate to the parent table or other tables (i.e. can't be reliably related by meaningful values in the data). Given that meaningless foreign keys...

Not at all - the code looks a fair bit more robust with your changes.

Thanks for your help folks - I'll have to be wary of this in future...

Let's say we have a string called strInput containing: 123456789#banana#987654 InStr(strInput , "#") returns 10, so we know the position of the first instance of # InStrRev(strInput , "#") returns 17, so we know the position of the last instance of # So InStrRev(strInput , "#")-InStr(strInput...

Hmmm... Name Autocorrect *was* turned on... and it does sound like a possible culprit. Does anyone know how I can configure Access not to set this by default for new databases?

I created a query and saved it I used the report wizard to create a quick-and-dirty report from it, but then I decided I didn't like it - so I deleted the report. I went to create a new report based on the same query and it just wasn't there any more. I had not been prompted to confirm...