Search results

I checked your suggestion previously as a matter of course and found no errors which was what prompted me to post as I couldn't work it out!! After some more searching I removed a 1 to many relationship with the "status" field attached to the append table and all is good. Thanks for the...

I would love to say yes, but in truth I dont know! I am self taught and have only been working with access for the last 2 years and vb for approx 4. Therefore there are some rather large gaps in my knowledge!!!

I run the following code to disable the Shift Bypass function & also allow me to re-enable it when required The following code is placed in a module Public Function SetProperties(strPropName As String, _ varPropType As Variant, varPropValue As Variant) As Integer On Error GoTo...

Having had a nights sleep and an early start this morning, I have had a look at append queries. The following SQL gives me the result I want within the query viewer INSERT INTO ProductLaunchCrossover_Tbl ( [GATE ID], [PRODUCT ID] ) SELECT LaunchProcessList_Tbl.[GATE ID]...

What I am basically working on is a projects database to control R&D development through to full scale manufacture thus ensure all tasks are completed when and where necessary. Currently the system is run via 100's of linked xls sheets all of which are updated individually and take an eon to go...

Thank you very much for you quick and concise response. I continued to work on this after my original post and came up with this '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Private Sub Command2_Click() Dim filename As String Set ObjFSO =...

I Posted yesterday in tables with regarding to txt. file import into access and a #NUM! error. Having sorted this issue, I am now pursuing automating the import of my .txt log files into access The code I have so far is below, this is working well with the exception of the file reference...

I came to the same conclusion this morning before I read your post, I can confirm it works this way Thanks for the help

Sorry the second Date & Time in the same field (Time & Date of Equipment status Change) Date/time: Y - M - D HH:MM:SS Is the format that is causing the error

Hi everyone As the title says I have been trying top link .txt files to a new Access table. Basically I have 3 x delimited log.txt files generated from some manufacturing equipment, it is proposed that that these logs are used to generate down times, efficiencies etc I have successfully...

The zmousetrap.ocx is an active x control that disables the mouse scroll wheel action when placed in a form

Your help was much appreciate, I will chalk it up as another access hissy fit Out of interest how did you ascertain that it was zmousetrap.ocx that was causing the problem?

The reference is present & pointing in the correct location. I have removed and re-installed the reference to no avail! I am starting to think I am going to have to rebuild the form.

Both the database and the zmousetrap.ocx are located on my desktop. The zmousetrap.ocx is working fine as I have used in other database's. I have just double checked and these will work on my desktop

Yes I do, any ideas on how I fix this??

As Requested, thanks for your time

Thanks for the reply, just before I got your response I tried both to no avail!!!

I have just finished putting a fairly complex form together & got a memory error. I had to shut down access and now I cant get the form to open in either normal or design mode. It doesn't even flash a warning it just does nothing????? I can view the form VB code Any ideas?????

namliam - Thanks for spotting that it seems to have sorted out the issue I was having. With regards to the the Join, as I am just dipping my big toe into the sea of SQL I have been generating the basis of all my SQL via the query builder and then pasting into VB & reformatting. I am slowly...

Hi pulling my hair out again!!! I cannot find the syntax error in my SQL and was wondering whether anyone could advise what I am missing. Please bear with me as I am still learning SQL1 = "SELECT MasterStaffList_Tbl.FULLNAME, MasterStaffList_Tbl. [START DATE], MasterStaffList_Tbl.UNIT, " & _...