Search results

Hi, Thanks for the responses. THE_DOC_MAN, I totally agree with you and anyone else I have spoke to that understands what I am trying to achieve is that the Windows task scheduler is the correct option. I have spoken to the head of our IT and it is an absolutely straight NO. It's quite a large...

Hi, I have been playing around with this and have hit a bit of a stumbling block. You will know doubt think this is long winded but I like to learn by trial and error and not just googling for answers. I have created a table that has two fields in it 'LastImportTime' & 'CurrentTime'. Using...

Hi Minty, Thank you for clearing up the Nz question that makes a lot of sense now. Looking at your code that definitely simplifies things, much appreciated. Thank you all for your time and input on this thread, I will mark as solved. Thanks miff3436

Hi Auntiejack56, That is brilliant and works exactly how I need it. I have adapted the code so it will enable / disable textboxes / Command button on subforms as well. Dim strPermission As String strPermission = Nz(DLookup("PermissionType", "tbl_Admin", "OneLondonName = '" &...

Hi, I have a table called tbl_Admin, this has 2 fields in it that identify the users of my database, these are "Loginname" & "userpermissions". I am looking for a way to enable and disable certain textboxes on a form depending on the criteria in the userpermissions field. The db opens on a...

Hi arnelgp, Yes that has done the trick, perfect. Thank you all for your help with this issue it is now working exactly how I wanted / needed it to. Have a good weekend all Miff3436

Hi arnelgp, I did that and now I am getting the following: error 3464 Data type mismatch in criteria expression. I have been through and had a look where there could be anything different and really cant identify the problem Thanks Miff

Hi Lightwave, I used your code and have just altered the form name and the listbox name to suit. Private Sub List19_Click() Dim stFormName As String Dim stLinkCriteria As String stFormName = OpenNIDrillDown stLinkCriteria = "[RecordID]=" & Me.List19 DoCmd.OpenForm...

Hi Jdraw, I can double click a record from the listbox to run a query or open a form but not filtering the record to the one I have selected in the list box. I'm not even at the stage of getting errors to be honest and was looking for some guidance. Thanks Matt (Access 2010)

Hi all, I have an unbound listbox named Listbox19 on a form, it has 5 columns in it of which one carries is a recordId. I also have a query named drilldown that also has a recordID field. I was hoping to find a way that a user can double click on any item in the list box and it will run the...

Hi pbaldy, The append query works perfectly, thank you for the quick response. Miff3436

Hi, I have a table that has 3 fields in it, these are autoID, Date, and username. Is there a way that I can auto fill these fields each time the database is opened by a user. I do not want any user input and for date I will set the default value to =Now(), the username to capture the...

Hi Mark_ Thanks for the options to choose from. As my VB skills are at the beginner end of the spectrum i am going to try a config table first. I will feedback for other users once ive tackled it. Thanks again miff3436

Hi Minty, Thanks for the response. This sounds like an option, stick with me its been a long time since I used Access. So if I create a table that holds a system time + Date stamp of the first import. When the db is opened it will look at the last date in the table and if = today It will not...

Hi Is there a way I can auto run a macro that will import once in the morning and also delete the same table in the evening. My company have disabled and will not authorise anyone to have Windows task scheduler on their profiles. At the minute I have an excel workbook that is dumped into a...

Hi Plog, Thanks for the response. That makes perfect sense, a case of not looking past the end of my nose. Each command button has this code but with a change to the line description value, works fine. Private Sub Command7_Click() DoCmd.OpenForm "frmMain", , , "LineDescription =...

Hi all, I am currently using MS Access 2007 and am trying to reduce the amount of userforms in my database. I have one large table that imports each time the db is opened. From here I have a form with 5 separate command buttons ( like a switchboard) each of these buttons opens a form...

I did not "JUST" ignore your answer from the previous question i did not get what you were saying, apologies if i am no where near your level but as stated i am quite new to Access, surely you had to start somewhere ! The reason i use forums is because the help functions are hard to understand...

Hi All, I have an MS Access 2010 db that has a main form called switchboard. This has 4 command buttons that open diffrent forms. Also on the main switchboard form i have an unbound textbox called TxtUserName that captures the users environ"username" when the switchboard form is opened. I...

The more i look at it the more it looks like the value in the switchboard textbox needs to loop through the table containing names of users. When the value meets an exact critera it will open the db. The values in the table are unique so cannot return multiple values. I will close this thread...