Search results

Hi Pat. Sorry about the pic. Thanks for help. I'll have a play.

Hi Pat This doesn't work but does it give you an idea of what I'm trying to achieve (or just confuses things)

Thanks. Please see response to Pat in next post.

Hi Pat, thanks. I'm the self taught developer as well as the client. Our rules are relatively relaxed. I had a play around with arnelgp previous post and example database. The example works a treat but I couldn't easily adapt it to my requirements. I don't necessary want to delete a new...

Hi all. Hope this makes sense. I have a master table (tblJobs) and sub table (tblPlant). tblJobs contains the primary data about a job. tblPlant is linked so that plant costs can be added to the job. Data is entered using a single form for tblJobs (i.e. the job) and then a sub form linking...

We have a master front end. I modify a 'beta' version that I replace the master with after all mods completed, C&R etc. When network users log in a script gets a copy of the master front end from the server and copies to their local profile creating their own unique front end. All users log...

Hi all. I'm happy we have a unique front end for each user. Not a single front end that everyone uses. I haven't checked out DocMan's suggestions yet - things to do. My C&R on the back end fixed the front end issue. Funny enough (not so funny really), I came into work this morning and...

Thanks for feedback. End of day and brain hurts so one for the morning. I'll update thread if anything to report once I've had a closer look.

Hi everyone. Sorry for the ramble, hope it makes sense. I'm using Access for data source back end tables as well as front end windows (objects - forms, reports etc). Back end and front end are split due to multi user front end requirements. All on on a local area network. We had a minor...

Hi DBGuy. Thanks for offer and help so far but I'll quit whilst I'm behind.:)

Hi DBGuy. Well I've had a go! Stuck with 1 as increment numbering. The code worked fine. Made the name changes with table and control/field bespoke to my database. Added the module (not had to bother with 'public ' routines but added it OK). Some of the code was beyond anything I've...

DBGuy. OK thanks. End of day for me and brain hurts. I'll have a look tomorrow and see if I can make it do what I want.

Hi DBGuy I wasn't meaning to be dismissive, sorry if it came accross this way. These forums are very helpful and I'm grateful to anyone who posts a reply. Here is a smiley face to prove it.....:) Just trying to go quicker than I should I think. Bugs only because I didn't read the...

Thanks DBGuy. 'Move up and down' method bugged out. Neither what I am after but thanks anyway. I'm looking for an automated way of doing all records rather than changing one at a time.

Thanks Adam, please can you point me to a web link or pdf. I think our firewall is being a bit keen. Many thanks.

Hi all I have a 'to do' list (on a continuous form) where I want to change the order of things periodically. I am using an incremental numbering system using 10, e.g. item 1 = 10, item 2 = 20 and so on. If I need to squeeze something in I can use e.g. 22 or I can manually renumber everything...

Hi moke. Worked a treat. Thanks very much.

Hi vba. This produced 1 folder called Job Title

Hi moke. I'm running the vba from a button on the form that houses the data. The form is a simple 2 field continuous form taken from the table tblJobTitle. Field 1 is the primary key and field 2 is called JobTitle. I tried using RecordsetClone and setting variables for directory name etc...

Oops sorry, MkDir "P:" & Me.JobTitle I do have the slash in there just pasted it wrong