Search results

That's getting a bit beyond me now. If that involves adding index's to the DB table, then that's going to take a while to get done, as I don't control all the tables in the DB, and trying to get the dev guys to do that will take forever and countless arguments.

I have some code (just written this evening) which I am using to check some alert that come through from data loggers. I am getting all the divide ID's I need to check (c970) and then looping through each one checking for the alerts. There are 5 alerts I am looking for, numbered 1,3,4,7 and...

I have a MS Access front end running on a MySQL backend and it works fantastically, the MySQL is hosted internally within the company not on the internet but same principal applies really. I found it worked much better than when it was an MS Access backend much more reliable and quicker, and...

When the user opens/logs in to the system, you could assign a variable with an access level for them. Then when your code fires use a select case on the access level and do what you want from there onwards.

No matter which way I tried this it wouldn't work, it would always put the detail section as the last sub report that the code set the control source to, or it wouldn't load when I opened it in print preview, something about not been able to change the layout once printing had started. Have...

Each page of the report needs to have the following; Same page header Same page footer Detail section - needs to showing a different sub report depending on the job type based on the information in the page header. All jobs are in tblFieldWorks and have a FieldWorksJobTypeID associated to...

I have a system that generates worksheets for the engineers. There are several different job types and work sheet layouts. Up until now, I have generated separate files for each type of job, but I want to put them all into one file. I thought I would create a report with: Page Header -...

Will move then round and see if that's works. The timer event is checking for any escalations that have been raised by other people using the system, and notifies me or other people above a set access level of the escalations.

I have a form which opens as a pop up when the system starts. On here are several buttons, which open other forms. Some of these just open another form and the user starts using the system, other close that form and open another one, and take go further into the structure of the system, then...

Scarp last, tried your idea of a view and calling that and it worked fantastically, info is there now by the time the form has open. Thanks

Could you expand a little on using a view in the BE and the record source idea please? With regards the filtering that wouldn't work so well, as there are many jobs, for various sites and having to work through them like that and filter it down etc would take longer than it does currently when...

I have a form for assigning jobs to engineers, this is based on a list box that displays all the jobs awaiting scheduling, and a second list box showing jobs currently assigned to the engineer for the engineer and date selected. When I double click on the top list box (jobs waiting) it assigns...

You can fully automate the process outlined, the only way you could automate it any further would be if the app just did it without you starting it ;)

If it were me, I would go with the select case, seems a lot easier to do. Select Case Me.UpgradeType Case 3, 4, 8, 13, 14 'hide unhide what you want here Me.AttackDice.Visible = True Me.Range.Visible = True Me.RangeLabel.visible = True...

Are you using Outlook for email? I would save output the file, create an email in outlook, attach the file to email, send/display the email then delete the file afterwards if you don't want to keep it.

Out of interest, is there any reason why it would be better to use an array rather than a select case for this? Something like this... Select Case Me.UpgradeType Case 3, 4, 8, 13, 14 'hide unhide what you want here Case Else 'What ever here End Select Or...

Sussed it. Very simple in the, just missed a couple of small characters from the line, WHERE (((tblfieldworks_attendedjobs.FieldWorksID)=[TempVars]![tmpFieldWorksID])))))") changed to WHERE (((tblfieldworks_attendedjobs.FieldWorksID)= " & [TempVars]![tmpFieldWorksID] & " )))))") Works a treat...

HI I have the below in a load of code Dim db as DAO.Database Dim rsEmail as DAO.Recordset set db= CurrentDB Set rsEmail = db.OpenRecordset("SELECT tblfieldresource.fullname, tblfieldresource.email FROM tblfieldresource WHERE (((tblfieldresource.FieldResourceID) IN (SELECT...

Hi I have a report which prints a label on a label printer that contains a barcode which is then stuck on the box. This works absolutely fine. The problem I have is when other people use the system. It runs from a MySQL BE and each user has their own network save FE with a link to it on...

After some messing around I finally got it working. Don't know what was wrong exactly, but something to do with the connection string, I don't think its the SQL and heres why. What I have done is create a pass through qry and save it within access, and referenced that instead of the...