Search results

I have indeed. I have a batch file linked to a shortcut, so every time they open the shortcut, it copies the file from a single server location. Makes it easy when I do an update, they just close and reopen to get the latest version. ~Matt

Hi Arne, The auto expand was already set. I have updated the list display but this has not fixed the issue. What boggles me is that it is only that combo, and only that client. Everyone else works off the exact same version FE and the other 14 clients are all fine. Likewise, every other combo...

Dear forumers, I have an issue with a single combo box, on a single machine. This form has 8 combo boxes I use to filter a list box. But I have an issue on a single client machine where 1 box, just 1, no longer works. Image is below. In every other combo box, once you start typing it starts to...

I am yes, but I also have that option for my main ribbon which is loaded without a form, so that always stays as the default. I want the main ribbon to stay, but when a form is open it gets its own ribbon, which becomes selected when the form is loaded. ~Matt

Hi All, I have some very nice custom ribbons and icons on my apps now, but I am now thinking of having form commands on their own custom ribbon too. Now I can get Ribbons to load with the form, but the default ribbon stays selected. Does anyone know how to get it to switch to the form ribbon...

Thanks guys, I shall leave it as it is. It is not a major issue, was just curious as I have seen other databases done this way. ~Matt

Hi all, Would there be any pros/cons to splitting my backend data into data types? At the moment I have a single backend containing all my tables. I was wondering if there would be any benefit in breaking this down into categories, IE Quote Data, Customer Data, Supplier Data, Employee Data and...

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