Search results

Ranman256 - thank you for that thought. I am not sure why I had that more complicated in my head. That concept actually helps across other areas. As well. For some reason, I hadnt considered simply having a field for students in the table issues. It makes perfect sense at this point. plog -...

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

Fair enough. I will go along with that. That makes life a lot easier. Thank you for idea.

JLCantara, The reason my supervisor can't null the specified fields that are being nulled out by the update query are because they are not a part of the form. The form is simply designed to allow the supervisor to select a record, verify the contents of the folder, change the status of a record...

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

So I played around with the query a bit and what I think is going on is that since I have the database set up to lock records once a user opens them up, the update doesn't take affect. I tried to just run the query manually without any code and it brought up an error that explained how many...

Mark, To answer your question, nothing happens. I have tried to turn it into a delete query, I have tried it as an update query. I have entered in Null for the update to and nothing seems to make the record change. I have tried to select different records and I have had no success with any...

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

robslob, That fixed things perfectly. Thank you for the help with that. pbaldy, That article will take me a little bit to digest. Thank you for directing it to me. Here is the code with the corrections. Dim db As DAO.Database Dim qd As DAO.QueryDef Dim rs As DAO.Recordset FolderName =...

spikepl, I don't disagree that I shouldn't dismiss what Access is saying. However, when I select the specific record on the form and run the same query against the record it works. Even the debug print returns results. So I am confused at how I can get information from the query, but that the...

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

Thank you for the help. I thought there wasn't much I could do but, wanted to ask anyways. One step at a time and eventually I will get things reduced and hopefully increase the speed at which things occur. Thanks again for the help.

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

CJ_London, I looked into what you mentioned and that seems to be the ticket. I just need to work on generating my code a bit to give me the desired effects. Thank you for the help.

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

Galaxiom, The single quotes did the trick. Thank you for your help. jdraw, The code ran past the debug and displayed in the immediate window the value in the text box. The final code that works looks like: Dim StrSQL As String Dim qdf As DAO.QueryDef Select Case Me.Combo3 Case "Full...

Galaxiom, I dropped the equal sign as suggested. Sadly I still have the same problem, just without an equal sign. I tried it on both just to make sure and neither of them work.

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

Ok so I wrote this up and it seems to work fine. TestNum = DLookup("MaxOfTestRequestNumber", "PrimaryKeyCounterQuery") + 1 StrSQL = "Insert INTO TestRequestTable(TypeOfTest, TRNumber, Requestor, TestRequestNumber, TestLocation, DateSubmitted, DateRequired, SampleArrivalDate, " & _...

llkhoutx, I am not sure what you are asking. I definitely have no idea what the QBE Frame is. Cronk, I changed it to a select and the information I am looking for is returned. I did some looking around and decided to try out doing things in VBA and not worry about the query designed in Access...