Search results

Are you in a Form? Are you looking to find out where these fields are located? You can goto design view, which is right above File and then View, Field List to get which fields you can put on a form. To find out the underlying table to these fields you can goto View, Properties and then Data...

for your query you will want the Sold checkbox field to be null, correct? Then you will want the Datein to be Greater > than the query date the user inputs. Should be a simple query.. I would think. So what am I missing? :confused:

It looks like to me you will need to setup your relationships in your database. How are you handling how these tables to be linked to each other? If you have a one to many relationship with customers being the one and orders for the customer being the many, this is an easy thing to do with...

Something that I found. At least coming from Excel to Access. http://www.pcreview.co.uk/forums/showthread.php?p=10974150#post10974150

If you want to prevent someone from opening the DB from the network or My documents or Recently used files, you will not succeed! FYI, Access is NOT the best at total security. :( But you can if you use the workgroup security, prevent people from opening the DB. (If they are not to hacker...

Maybe its my brain that is thick. How can you have several DB that are identical? Can't you then just use one and delete the others? Why bother merging?

umm.. If you have a relationship between two tables that is organized on an ID, say contact ID number, you should be able to have a form that opens up when you click on the button and edit the additional information you need. Or have a sub form that show the additional information in the...

One way might be to use a columnar form and a regular form. On the Columnar form's double-click properties you will have the call to the "sub" form. DoCmd.OpenForm "Frm Second Form" Where the "frm Second Form" is your regular form, not a real sub form. Just a thought! A sub form should be...

Hmm.. sometimes a person will open the database in Exclusive mode. File Open, then in the bottom right corner is the open button. You can click on the down arrow and select which mode to open in. Or you can assign exclusive mode to a shortcut when you run access. Search through the forum...

When I ran a subform query for two criteria this is what I got: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmAuditProcessWork" stLinkCriteria = "[Supervisor]=" & "'" & Me![SupervisorNameBox] & "'" & " AND " & "Month([LogDate])=" & "'" &...

If you have a query to export the stuff.. Dim TabName As String TabName = "RRA" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry-TP Task-Daily Report", "C:\Task Reports\" & "TP Cor " & Format(Now(), "mm-dd-yy") & ".xls", True, TabName Just use a query and give it a directory...

Check out... http://www.access-programmers.co.uk/forums/showthread.php?t=134929 Which takes you to .. http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=285

First, you will need to kill the Autonumber and replace it with Integer value in the tblBatch. (You can include an autonumber, just name it different than BatchID) You will need to make the new field BatchID the PK. (I think) Then for the following: rs.AddNew rs!BatchDateTime = Now()...

Unfortunately, you are really going to have to think about what it is that you want! If you want a simple database that has employee names linked up to an employee number, that does not require a database. But, if you have an employee attendance issue, that would be nice to have a database...

If you are using code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry-TP Task-Daily Report", "C:\reports\" & "TP Cor " & Format(Now(), "mm-dd-yy") & ".xls"

A couple of things to play with.. Could you use a temp table for the subform and then when they click on "save", you update the real table? Could you just use a simple "Are you sure that the data is ok?" popup asking to click Yes or No. If they click yes, let them go on, if no, keep them...

Wardy, I usually will add a 2nd table that houses the items for my drop downs, combo boxes, etc. That way, I can change the table so that if I need new items to choose from, that can be done easy. I can also setup an new form that will allow me or others to add to the combo boxes (Even Gasp...

Ex) TabName = "RRA" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry-Task- Daily Report", "c:\Task Reports\" & "Task Cor " & Format(Now(), "mm-dd-yy") & ".xls", True, TabName The DoCmd is all one line. The query is Qry-Task-Daily Report, the location you want it comes...

Search out Dlookup and Password on this site Here is one way.. http://www.access-programmers.co.uk/forums/showthread.php?t=130141&highlight=Dlookup+Password

In one of my databases, the user is to select items. If they select one in particular, the invisible sub field pops up to be entered. If one of that new pop up list is entered, another pop up field shows visible. Private Sub CorrectResolutionYesNo_AfterUpdate() If Me.CorrectResolutionYesNo =...