Search results

I am sorry but the example DB I posted was to specific and it looks like no one matches all the courses required for a specific position. I'm going to create a smaller simpler one to make it more effective.

Yes that is correct jdraw

(Removed Attachetment due to bad data) Here is the example db with some data in it. I'll try to fix up an excel sheet but problably will not be done before you leave. In the DB just open the only form there and hopefully it will explain and give you a visual of what I am trying to do. Thanks

No problem I'll start producing an example and I'll post it as soon as possible. Thank you for your time.

Ok let me try to give an example: Some user inputs a new position in the [Position] Table. Then he sets up which courses are required to fill that position. So example data of this would be: [Positions] ID = 1 Position = "Tradesman 1" [Position Courses] ID = 1 PosID = 1 CourseID = 3 ID...

If I understand the question correctly the [Positions] table gets filled with a position name and then the user selects using a combo box all the required courses required for that position. This data is then normalized into the table [Position Courses] as the criteria for that specific...

I am a little lost right now on generating a query to show an employee that has all the required courses to fill a position. Any help is greatly appreciated and I'll try to be as clear as I can on the DB schema. [Tables involed and their makeup] [PositionsList] ID - AutoNumber Position -...

No worries.

Ok so I made the changes I believe for what you wanted to do but remember you will need to fill out the required information and setup the tables correctly for the fields that you want to pull in.

If you can please upload an example file of the excel file with dummy data. Also are the newly created field names called "Customer Name" and "TPM" or are they different names? Finally the data starts on row 33 are there other rows after that if so what is the interval between them etc...

Yes all that is just fine. You will need to modify the code a bit to make it happen. If you like just tell me which columns are hidden and where you want them to go in the table and I'll make the changes for you today.

Thanks Pat for your input but remember this is just for fun. I am planning on making it so it can read the relationships from the BE or whatever database you tie it to and having it flatten the data where needed. This is not ment for any kind of production environment... yet anyway. The...

Lol I like your responce but honestly its not a practical approach. I do understand where you are coming from but the idea is that it will flat line the normalized structure without having to teach 100,000 people to learn access. It's more cost effective to have an interface like this with or...

Ok so this is sort of a side fun project of mine (if there ever is such a thing) where I designed an interface that uses a treeview control to populate the table names and field names I want the users to have access to. Then all they do is select the fields they want to include in their query...

No unfortunatly not like that because once it gets to that point its just building the array to process the data. If you make the directory static and not use the browsefile function then that would do the trick. Or (which may be the best option) is when the dialog box (or filebox) comes up...

Thanks guy's for the input. I knew there was a better way but I was blinded and didn't think about that approach. I should have caught it but ow well. Pat sorry for my code not being clear. I'll make the consideration the next time I ask for some help. Appreciate the combined effort. Thanks...

Here is my core function to do what I am talking about maybe that will clear up any questions or maybe I'm going about this the wrong way I dunno but here it is. Function ImportTAndL(strFile As String) Dim xlsApp As Excel.Application, xlsWorkbook As Excel.Workbook, xlsSheet As...

Yes because this checks every record being imported so I have to search to see if that record has already been imported. About 17 thousand rows of data every sync operation it has to go through.

Sorry forgot to post my code... rs2.FindFirst "[Shop ID] = " & LookupShopMod(CStr(var(ii, 1))) & " AND [Project ID] = " & LookupProjectMod(strProject) & " AND [Badge] = """ & CStr(var(ii, 2)) & """ AND [Start Date] = #" & Format(CDate(var(ii, 11)), "Short Date") & "# AND [Total Time] = " &...

I am trying to figure out what the proper indexing should be to maximize my searching ability but also give me the fastest update ability. The tables in itself are very simplistic but after the rows reach about 17K or so it starts to slow down and I am pretty sure its my indexing that's causing...