Search results

I have a copy query I created for users when they are creating similar records. This is supposed to help reduce input time into the system. The problem I am facing is that the copy query isn't working. Part of why I think it isn't working is because I have the auto number shut off on the primary...

Well after spending sometime trying to create a sample db so I could show what was working and not working I got things working. Ran into a bit of problems making sure all of the tables, reports and queries were copied over. In doing so I had a problem with the ...

spikepl, I did try what was suggested in multiple fashions and had no success. I don't ignore what people suggest, I give things an honest go. When I did what he suggested I got the the SQL string that I have. I imagine this has something to do with the recordsource not being opened to obtain...

I have a query that I set up to return multiple records. The number of the records is in that text box. I have tried to set the where clause to the text box but for some reason I don't get any of the records I want returned. I am using a Where... IN statement. I have tried to put the numbers in...

Sorry I haven't gotten back sooner a power outage reset some things and I had finals. To answer your question when I run my code I get what the string says only because I think I am not opening it as a record source or somethings. I can run different types of code and get the numbers of the...

Ok I get what you are saying now. By using a pre-built query then before the report is opened we are modifying the query to look for something different that is handled much better in VBA. That makes a lot of sense. That being said, I input what you suggested but it is still returning all of the...

namliam, My bad on that, clearly wasn't awake enough earlier, it is a sub report not a report. My main report returns everything I need it to. The reason I have a sub report is because of the difficulty I had with relating the multiselect field to the ID field. Since we sometimes only generate...

JHB, I had previously tried doing what you suggested and put in random ID numbers. It worked just as expected. When I went back to the GetCalEquipment it stopped working again. namliam, Where I have used SQL before in VBA I haven't used VBA for the record source of a report. I can modify what...

I have a sub report that is based on a query. The Where clause of my SQL is giving me a bit of hang up. What I am attempting to do is return the records that are the items used to test products we test. The ID's of the records are gathered in a public function. The function is called...

Figured it out. Looked at an older system and something just clicked and sure enough I found something that works. Here is what I put into my text box to adjust the max pages. ="Page " & [Page] & " of " & ([Pages])+([Forms]![ReportForm]![PageCount])

I have a report I want to generate in Access 2010. I have a text box with the following: ="Page " & [Page] & " of " & ([Pages]+[Forms]![ReportForm]![PageCount]) What I am attempting to do is increase the maximum number for the total number of pages in the report. As it reads right now when I go...

I have about a dozen total tables. For the purpose of this discussion I will just go over the ones that matter. I have 1 main table that collects the information about the test to be conducted, I am giving a briefer list of items on the table, this is just an idea of how I have it set up. I will...

I have a more general question then a specific one. Kind of looking for some guidance and opinion of what to do. To give a bit of back ground to understand where I am coming from and would like to go. I use access to gather information on testing that is conducted at my company. In the database...

Those are all valid points. However, regardless of how it should work, it doesn't. Specifically, point 8 in what they are not. Microsoft has commented on said such issue. The problem is that I have to generate a work around. So I respect the points made and all are exactly what I have come to...

I agree the Auto Number should be unique. However, on more than one occasion as of late I have run into an issue where that isn't happening. The Auto Number has started as far back as 20 digits. For example, the next unique number in line should have been 2276. However when a user attempted to...

When I create a new record I am also generating a new Auto Number. This is so I have a sure fire way of returning the records that I want to return. I have read where it is a known issue that when using the Compact and Repair it can reset the Auto Number to a lower number and generate a...

Thank you very much spikepl. That was the information that I needed and the recordset worked great.

When I went to run the query the first time no it didn't return the desired results. I looked things over and noticed that the one field had its name split apart. When I fixed that it worked perfectly. It is a saved query. The form TestRequestNavigation stays open till I close it at the end. I...

So I put the SQL statement as a SQL string in my vba area. I then ran a debug.print. I copied the print into a new query in the SQL Section. This is how it looks SELECT TestRequestTable.TestRequestNumber, CrouseHindsPersonalTable.FullName, TestRequestTable.IndividualComponent, ComponentTable.ID...

No not disagreeing with you, just trying to be informative. I pull the record based on the primary key of my main table. The rest of the query is just fields from related tables so as to aquire the needed data. I tried to make it a simple select query.