Search results

I have an access 2000 database, that is split as an MDB backend and an MDE Front end, it serves approx 30 users and help to control R&D of new products. The database has been running problem free for 18 months, I was recently asked to alter the base task generation and reporting. Unfortunatley...

Public Sub PlannedManufactureCsvUpload() 'UPLOAD PLANNED MANUFACTURE TO COGNOS CSV If MsgBox("Upload Planning Data to Cognos" & vbCrLf & vbLf & "This function will take 3 - 4 min depending...

Ive done a good 4 hours of googling and searching to no avail so would appreciate some direction. I have the following code:- Private Sub Command71_Click() Dim SDate, FDate As Date Me.Text74 = Me.DTPicker7 - 1 SDate = Me.Text74 Me.Text76 = Me.ActiveXCtl68 + 1 FDate = Me.Text76 DoCmd.RunSQL...

A Brief background I have a Projects database to create and track new product development, BE on the server, FE as an MDE application for users I have the following setup within the FE A Form to enter project specifics, i.e customer, product etc Append query on save to create a separate...

Hi some more advice and guidance is needed :) I am in the midst of building an access application to import and sort CSV files generated from plant equipment. I have the files correctly importing into access via VB code. Within the code the file location is selected via an open dialog box...

Not sure whether this is the correct area to post this in so I apologise n advance I have been working on a projects database and have got to the point of multiple users accessing and writing data at the same time. The Database is deployed via an MDE FE across 03,07 & run time machinery. The...

Not sure if this should go here or in the queries forum? I have a projects database near completion that I need to distribute across 30 + users, some don't have access while other have 03 and 07. I have split my database into FE & BE, I have compiled my code and created an MDE front end to...

Hi need a little help with how to get an SQL insert string to recognise VB variable as the insert values. Basically I have a Project Management Database I am working on. Each project has 281 standard steps split into 8 gates. The powers that be have a meeting every Monday to discuss and...

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

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

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

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

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, " & _...

I keep getting the above error in my code and don't understand why as it has been working for weeks!!! I have a form with 3 combo boxes that I have been using as a filter for another form. This has been working fine and I don't recall changing anything within the 2 forms recently. Some advice...

Hi again, sorry for all the post asking question rather than answering them im still a little green! I have the following code setup to alter a query before opening a form within VBA, I have the code place in a buttons OnClick Event and the code is referenced via a separate module The code...

I have a form in my current project that I need to copy and use to control data input into 10 different tables, i.e 1 form for each table. Each form has 168 text boxes which I need to change the Control Source and name of. I know how to change a forms control source and an individual controls...

I have written some code to alter the format of a text box when a specific date range is found in the Dlookup. Please bear with me I am relatively inexperienced in VBA! Private Sub Command590_Click() W = Now() Dim X As Date Dim Y As Integer X = DLookup("[ISSUE DATE] ", "[MasterWiList_Qry]"...

Has anyone tried to do this before:confused: I need to split the form into 4 section, 3 of which I need the function to collapse or expand If this is possible could someone point me in the right direction please Thanks

Hi This may sound basic but I am completely stumped. Funny how the simplest of problems can become the most difficult to solve! I have an issue with a field within my pivot table basically the pivot table will only return a value of 0 when the query returns a calculated value and the pivot...

I have an access 2003 DB that is deployed across a medium sized business, unfortunately we need to purchase new computers and they will come with vista and office 2007 Has anyone had any issues with running access 2003 databases with access 2007? Any info would be greatly appreciated as I...