Search results

I have a batch file that I use to import the latest version of each "app" I create. I store the new FE in a folder with all images and such, and the user has a shortcut on their desktop to the batch file. When they click, it automatically clears the local C: folder and then copies over the...

I was trying everything, but I just fixed it. It was because Vertical Scroll Bar was turned on. I turned this off and changed the border to Sizable and it now looks as it should. It has been bugging me for a while as some of my other apps also had this issue and I just ignored it. ~Matt

Hi All, I have edited a form from the interactive planner we have purchased and I have an issue. It seems to be adding extra form to the right when in form view. This is not here in design view. As you can see below, when in form view it is adding 0.5cm or so to the right. I have tried...

Just in case anyone else is looking for something I found the below, and it was only €100 for the full editable version. Well worth a look and, while I cannot tie it in to my existing data, it works better than anything I could have created. ~Matt

Hi Arne, I have put my data in but it gives an error, No Current Record. If there is 1 line of data in the job table, it works. As soon as you add a second line, it says no current record. Could this be due to potentially overlapping dates? ~Matt

Hi Arne, That looks almost perfect. Am I right in thinking I could manipulate the query to take the end date and work out a start date based on how many hours I have calculated for the job? ~Matt

Hi CJ, Please see below. TRANSFORM Sum(qryCapacityPlanningLabourTimesMonthWeek.[Job Time (Hours)]) AS [SumOfJob Time (Hours)] SELECT [EmployeeFirstName] & " " & [EmployeeLastName] AS Employee, qryCapacityPlanningLabourTimesMonthWeek.[Assembly Type] FROM qryCapacityPlanningLabourTimesMonthWeek...

Hi Pat, I have this working now with the weeks I need displayed (based on the selected month) and the full employee list, which is great. But it has a blank column with <> at the top now. I am assuming this is something to do with me showing all records from tblEmployee and only matching...

Hi Pat, How would I force the cross tab to show all employees even if they have no jobs assigned? I know I can force columns to appear, but how would I force rows? We currently have 25 employees, but in week 27, for example, only 7 have assigned jobs with a due date. I would like the crosstab...

Thanks Pat, I shall have a look into this. I hadn't even thought about cross tab. ~Matt

Hi All, I was wondering if anyone had a very basic planner form they have used. I have searched the forums and there are plenty out there, but not quite what I am after. I am trying to display employee workloads and I have a table with a due date, and a query with labour hours. I want to be...

Thanks Maj, I have never coded a loop before but I will find some codes and give it a go. ~Matt

I tried 2 methods of copying the data from Sage STOCK_TRAN table, 174063 records. Method 1: I use a query to make a local copy of the table then append this to my SQL table. Took around 1 minute 30 seconds to action both queries, then truncate the data. Method 2: I use a query to append the...

I have this working now and the TRUNCATE on the pass through works perfectly. Finally I can make use of Sage tables without having to use the horror that are the Sage tables. Thank you all. ~Matt

Thank you. I shall learn this now and see how I get on. ~Matt

How would I do this from access though? I need this to be able to be done on any client FEs that need to do it. ~Matt

Truncate doesn't work in MS Access, not that I can find. With regards to the import, I have 2 queries and use a make table to move the data locally, then append the local table my SQL table. These 2 queries run faster than trying to append the Sage table to SQL. Now I just need a working VBA...

Thanks Maj, I now have the import working in flash. The issue now is deleting the data from the SQL table. I need to find a way to TRUNCATE TABLE in access as the delete function takes upwards of 20 minutes each time. I have no reason to log the records that are being deleted as they are only...

Hi Pat, The data I am appending already has a TransactionID. What I am trying to do is append them in smaller batches, rather than a single query doing them all in one go. I want a query to loop through 1-1000, then update my label, then run through 1001-2000, then update the label, and so on...

Hi Minty, Thank you for your reply. There is an ID field and breaking it into 1,000 or even a 10,000 loop wouldn't be an issue. Yes, the Sage ODBC is the bane of my life. ~Matt