Search results for query: *

Thanks [COLOR=blue]TheAceMan1[/color blue], your code hit the spot very nicely thank you. I did add the following line: AppUser = Trim(AppUser) just to tidy up the returned username. Thanks again, Nick

Thanks Roy-Vidar and TheAceMan1. I'll be following up your advice directly. MichaelRed, in almost all respects you are, of course, right. The thing is that I am trying to avoid anything to do with the normal route of implementing security etc (does not matter if this data is secure or not)...

I have a database which is to be used by 4 users. I intend setting things up so that there is one backend and 4 x frontends. Each frontend will have it's application name (seen in the main application titlebar) set by the following format: "<project name> - <user name>" Since I have made it...

Thanks for all the additional suggestions. Pete, sad to report that I could not get your idea to work. Seems that, although the dafault value can be changed programmatically, the form only stores the info whilst the form is open. When it is closed all changes are lost and the form defaults...

Was driving home before I realised I had not awarded you guys some stars! Thanks again for pointing out the options. Nick

Thanks guys. Thanks for the idea Geoff but I am expecting users to only very occasionally use this form (i.e. 90%+ of the time it will be closed) so hiding doesn't seem to be the best option in this case. I like your idea though, it is an option I have used elsewhere but only as a temporary...

Being only an occasional VBA coder I occasionally struggle to convert my usual programming practices (ArcView Avenue, Perl) into somthing that works in VBA. I have a form with around 30 checkboxes. The purpose of this form is to act as a 'user preference settings' control panel. The 30...

Thanks for the thoughts. Unfortunately, at this time, I primarily want Project to assist me identify the best of several possible plans. The tasks specific to me come to an end fairly early on in the project. Naturally, I would then expect to participate in whatever tasks are remaining to...

I am currently trying to work out several different project plans based around differing levels of staffing. There is a fixed amount of work to do and I wish to see how the end date for the whole project varies for each scenario. I have a team member/resource (me) who is assigned to several...

The data has been poached from another database and so comes in the format as described. There is not an alternative source for this data. [Field A identifies individual streets. Field B represents sub sections of a street. Field C represents sequential points in a vector line that describe...

I have a table (50,000 records) that has data in it that follows the form below. Field A is the main identifier of blocks of data. Field B identifies sub-sets of the data. Field C then gives the number order of data within the sub-sets. Field D represents what I need to achieve: it provides...

My bad. Forget 'Key' in 'Area ID'. It was not necessary in the 1st instance and a typo in the second (should not have been there). Thanks for the tip, I now see that I can select 2 fields as Primary Key. I seem to have a problem doing this however as Access will not let me have duplicated...

I have a 3 tables (Wards, Areas & Streets) which have the following relationship: &quot;Wards&quot; &quot;Areas&quot; &quot;Streets&quot; Ward ID ------ Ward ID Ward ID Ward Area ID ------ Area ID other fields Key Street...

Cheers for the pointers. It still took a bit of doing (its a steep learning curve I'm on) but I got the update query part working well now. I'm now moving on to the bit where I check that all streets in an area are cleaned or not. Thanks for all your advice. I may yet have to be back for more...

Cheers for the solution JonFer. I had previously tried to implement a similar method for updating the Streets table but with no success. Your method sounds bang on the money. I am new to Access and especially VB and whilst I see what it is I am trying to achieve I haven't managed to implement...

Are you at work over this festive period? Do you need a distraction from the mundane and workaday? Be charitable and take pity on a befuddled Access newbie! I have a database of 5 tables. They refer to geographical information for the area covered by the council I work for. They are 'Ward'...

Cheers again Frederico, I hope you do not mind but I have one other thing that the VB would ideally do. Could it prompt the user to specify/create an output folder? If so, great! Enjoy your week off. Please don't spend any of your precious holidy working on this! Have fun, Nick.

the macros I have created so far appear at the end of this posting. I now offer this breakdown of what the 2 macros do and what I needs help with. part1 - does the initial import (of data previously copied to the clipboard) and seperates the blocks of data to one per page. it then does a paste...

Assistance please. I require assistance with some Visual Basic (V.6.0) macro programming for Word 2000 under Win 2000. THE BIG PICTURE: I have the output of a query of a database which is a 6.8MB text file. The contents of the text file is a list of possible duplications of data within the...