Search results

I have a question about table design. I will be using Access 2010 or 2013, that shouldnt effect my question. My buddy and I are designing a database at his school that is going to collect information on students like how often they use their phones in class and other issues that come up. We...

I am working on updating some features and code for my database. I have different access levels to my database. This system was intended to collect requests from users for testing to be conducted. A supervisor form to handle the requests was set up. I set up that form and forms that could allow...

What I have a a form that my lab supervisor would use. That person selects the records that are to be modified and assigns work, completes work or otherwise updates the status of the records. One of the options is to mark a record as not having a sample here if it has already been marked as...

The other day my database started having some problems. I have two copies. One on the server that only gets changed when I have a fair amount of updates to be added to that copy. I also have a copy on my desk top that I tinker with. They both have the same back end. The problem is that the one...

I am working on enhancing the database I designed. I am trying to improve speed on the code I do have by switching multiple dlookups for recordsets and building better queries and reducing the number of them that overlap. So I was wondering about exporting reports to pdf. I do this a bit with my...

Ok, so I have a database I designed and have been working on for 2 and a half years. I think I am fair at what I do, though I still need nudging. Since I am working on updating things in the system to enhance performance, I had an individual ask me a question that I have no idea about. Part of...

So I have created a select query and I am using it as an all purpose search query. I plan on changing the value of SQL in the query based upon what the user selects as the method of searching. So there is a drop down menu, that allows the user to select the method, this will be expanded in the...

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

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

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

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

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

I am currently working on enhancing my database at work. I am trying to open up a recordset. The problem is that I get an error that says too few parameters expected. I am using a query as the recordset and it does return the one record that I want it to return. The recordset though doesn't seem...

Ok So I admit when it comes to crosstab queries I am pretty much clueless. I have gotten a few to work in the past and have a general idea of the mechanics. That being said, I am trying to pull some metrics for the year from the database I designed. What I am attempting to do with this...

So I have a bit of an interesting situation. I created a database to track test requests from engineers. They fill out a form and things work from there. Well to increase the speed of them inputting requests, because some are virtually the same, with the exception of one item, I use a a copy...

I am running into an issue with the date picker(the little calander that pops up next to the text field). I am using Access 2010, the field is set to date/time. The problem is that users suddenly can't use the picker. They can type dates into the field and it works. Just looking for any ideas as...

I am working on setting up a loop that will get information from a query. I can handle the rest of the code once I get the primary piece of information. Which at this point I can not get. I am trying to get to the next record of my query. For some reason I am stuck on just the first record and...

I have a report that pulls information from 8 tables. The query behind the report generates all of the required information I am looking for. Though when I go to open the report it says that a table could refrer to more than one table listed in the FROM clause of your SQL statement. The only...

I am having a problem with retrieving the information I am looking for. Basically I am checking to see if a user has selected a TRNumber from a drop down menu and if that TRNumber matches any other records in the table in that field. If it does, is that Number already associated with the user...