Search results

Thanks rak and SJ McAbney Adrian

Hello I have just found out that i have been used by the company I work for (I am sure there are plenty of similar stories out there :-)) but this is not a whinge just looking for some advice. Can anyone help point me in the direction of decent IT recruitment companies? Consultants names...

DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.GoToRecord , , acNewRec DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdPaste I use the code above to effectivly copy and paste the information from a record to a newly created one. This happens on a fairly regular...

For anybody who looked at the example i attached to the initial post the reason i want to Null DTReason is that there should not be a down time reason when the line is running only when it is not running. Regards Adrian

I am copying and pasting a record using the code after a user updates list boxes. Private Sub cmdStart_Click() InstanceEnd = Now DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.GoToRecord , , acNewRec DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdPaste...

Please ignore Sincere apologies I have commitied the cardinal sin and not rebooted the machine. Its the first thing i ask people to do. Its the first thing you should do. It solves 99% of all problems and i didn't do it. Everything is cool now as you probably gathered i went into a huge panic...

Thanks for the reply Steevie I am still at a loss as to why the acCmdPaste has stopped working after i downloaded the sample DB though and i am not sure what else might have happened. Can anybody help me out? Adrian

Hello all I was looking for a way to clear the clipboard and after searching the site followed a link to candace tripp's site. After downloading the example below I was trying to work out how it had been done when i encountered a problem which has stopped my DB from working. In that the...

Thanks for the response Peter I am sure your code is right but i have not had a chance to try it yet. The problem i was having was that i was unable to reference UniqueShiftCounter in the VBE. But i have been looking into it further and after pulling the field from the table into the form and...

Just read the last sentance again and it is not very clear. To clarify each record recorded on that particular shift (which are not set times and can run over multiple days) has to have the same unique number attached to each record tha is created during that shift. So when i go to run a report...

Hi RG and Peter As you can see Peter I have taken your advice over the tab contolled form and its working much better. I overcame the original problem by copying the previous record and I am going to set the relevant values back to null as the situation demands. I am also aware that my DB is...

I am refering to the table. e.g. Field = DayStart in tblProductionDetails. I then want to go into the module and insert DayStart = NextValueCounter I have done this for other fields in the table without a problem just by going into the module ctrl + space to find the field and then inserting...

I added a field to a table and then went to reference it in a standard module and its not there? i.e. pressed ctrl + space and didn't appear in the list so i tried referencing it anyway and no joy. I feel sort of stupid posting about it but after many hours of checking and comparing to all the...

Thanks for the reply its appreciated as I know that this can seem like a pretty basic question so not very interesting to a lot of people but to me it was a bit of a headache (we all have to start somewhere) and i am trying to pick up good practice from the outset rather than get into bad...

I need to achieve different results at different points in my TAB controlled form depending on the user input (or lack of it) after a varying lengths of time. For example if there is no user input after 5 minutes i need to set of an alarm and MsgBox to prompt for it except when "Break" has been...

Thanks for the post Peter I have just got back after having my wisdom teeth out (thought i would be able to keep up with the forums and get some work done at home but the cocktail of drugs and a general anestetic they give you really knock you out (the screens still a bit wonky)). I did manage...

Thanks for the advice Peter I have also spent some time looking at tab control within forms and you are right it will definetly be easier using this method rather than lots of different forms although i can foresee a couple of problems which I hope you can help with. 1 can I hide the Tabs of...

Hi Peter I will have a good look at my table layouts and it looks like using Tab control could be the way ahead. So after a quick bite of lunch I will start searching the forum and learn about it. Thanks for all your comments to date. Everything yourself and Neil have posted is adding to my...

Hello Neil Thanks for your response InstanceEnd being a field not a control has me confused. I am trying to insert a time value (hence Time rather than Now()) into the field of the record. I have had trouble with Now() in the past (especially as shifts often span 2 days) and i am going to...

Hello again Peter I would like to use a single form as well but unfortuanatly the data entry process has to be very very simple, i cannot use a keyboard or mouse and the text on the forms has to be very big. I suppose i could copy the data from each of the forms that opens into a hidden form...