Search results

I am trying to setup a table the best way I possibly can and was just hoping for some opinions. I have the need to store potentially 313,000 rows of data multiple times a month. I have tables that have around 3 million rows of data in them but they are a bit sluggish. I could reduce the number...

Hey all it's been a while and hope everyone is doing good :D I have something I am trying to figure out what would be the best way to setup multiple rows for calculating men per day usage. Here is an example of the data in a table: ID, Class, Start Date & Time, End Date & Time 1, Excel, 1/9/16...

Hey folks, I am running into something that really is kicking my butt for some reason... When I try to run a simple update query written in VBA I get no errors but the field that I am trying to update just gets a 0 instead of the appropriate ID that I am passing. Any help on this is...

Good Day All, I am looking for a little help on creating an good solution for calculating out someones experience based on a specific start date. I've created some code to start the process but it's still not quite right. Here is the code: ' Format Experience field eYears =...

I am wondering if anyone has figured out a way to make objects to support adjusting continuous form controls making them unique in a sense to be able to change info like captions or whatever. I've been working with collections for a while now tapping into event handlers such as the mouse...

Hello all, It's been a while and hope everyone is doing ok. I have a question and it's maybe more on a basic level but when I open a query that has results with more than 200K records when I click on the date field it takes a while before it gives me the selection of the dates to filter with...

Hello all, This is something I seem to battle with a lot is what is the fastest most feasable way to modify remote data (meaning a front end trying to modify backend data). I have created many projects and have been able to mitigate most of them but this one is eluding me. Any help is...

Good Morning Everyone, I am looking for some opinions on the fastest way to locate text within a text field and assign a value if specific text is matched. So here is the scenario: Lets say you need to locate the word WPV, NVM, and WKZ in everyrecord between a certain date and time. So...

Hello all, I have been doing research for a while now and while there seems to be plenty of information on how to create a power point slide from access 2003 or earlier, I can't seem to find any reference for Access 2007. The difference is how the slide is created between the two versions...

Good Evening All, Does anyone know if you can setup a query to pull in table data and use it like a not in list type of filter? Meaning if the data was this: 1 WV 5 2 WV 6 3 NW 4 4 WV 8 And in the not in list I would put that I don't want NW so then the data would be: 1 WV 5 2 WV 6 4...

Good day everyone, I have litterally :banghead:b/c I have a simple totals query that does not want to total for any groups except for one of them. So I'll try to explain. The data getting returned by the query it's trying to total looks like this: Fields: Charged Date | Home Shop | Borrow...

I am looking for some advice on the proper way to figure out the earliest date and the latest date between five tables. I know I can do this by creating a query for each table only pulling out the date field in each then using a union query to put it in one dataset then run a query to return...

Hey guys, If I have a table with four fields in a single index that I called "Test01" in vba would I still search for the regular named fields and it automatically pickup on the index or do I need to call that index somehow to properly search the index? Sounds silly but any help is greatly...

Good Day All, I am looking for some good information on how to properly normalize dates in access. I have read many things and have actually normalized dates before in the past but I can't help but feel that there is a specific correct way to accomplish this without having to jump through many...

So I have been doing some investigating but have not found a good solution to my current problem. I have two tables. The first table stores jobs The second table stores different statuses on the job Its a one to many relationship but for meetings and other purposes I need to show all of the...

I have an issue where my Exists function in my Append query keeps giving me this error message "AggregateType is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not to long." Here is the exists line. Test: Exists (Select * from [SDSK...

I have a mind boggling logic problem that I just can't seem to put my finger on what to do... I am trying to find all training that is happening during the period of one week. While I have been able to get this to work with using a between statement there is still a problem where it does not...

So this may be a simple problem to fix or maybe its just the way access works but I have many queries where users can view as reference data. The problem I am facing is that when the user first opens the query they can select the little arrow next to the field and select what they want to filter...

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

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