Search results

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...

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...

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...

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...

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...

Hello All I am creating a production line database for use on a touch screen (no keyboard or mouse) which has to be really easy to use. At the start of the week i got to the point were i thought i would test what i had done to date and have come across a serious issue. I thought that the data...

Could anybody point me in the direction of a simple / step by step tutorial on global variables. I have searched the site and read through other threads but I am still having trouble defining the listbox selections on my forms to a global variable module so that i can use them in other forms...

I have a number of forms with options on and then the user clicks a command button which is meant to insert a an InstanceEnd time into the underlying table (the InstanceStart has already been populated) Create a new record and insert a new InstanceStart time into the new record the user is then...

Hello all I have searched the site for an answer to this but still a little confused i would like to set the height, width and header height of all my forms to a value which i know and also the positioning, size and font size etc of the list box which appears on these forms ( i have tried...

Hello everyone I am reasonably inexperianced with Access and VBA development and need some help with something i thought would be realitvly easy . I have a number of forms that are linked to tables that allows users to select variables which complete the fields in a record. However in a...