Search results

Hi, I have a query that groups and sums. I need to do this to get the source data where I need it for ongoing processes. Once I run the query the results work perfectly. I now want to take the results and append them to a new table. The problem is all fields will come in execpt the SUM field? I...

Hi, I have an unbound textbox on a form. Is there any way to take a value from a query and place it in this box? I have been playing with the dlookup but cannot seem to get it to work. Thanks.

Thanks, do I need to create any relationships between the tables, A, B, C before I start to add the subform?

Hi sorry, I am clear on the Mainform etc.. I am adding the subform (People) to my main form no problem however I want all of the data to show in the subform. Currently it is only showing the People ID and I can select them as needed but it does not show all of the other data such as name etc...

Pending any relationships created with the tables, when I go to add the subform based on the JunctionTable what do I add to my main form? Do I add the JunctionTable or the PeopleTable? Please forgive me it has been a while since I have done something like this.

Most grateful, many thanks! DB set up as indicated. Do I need to create any relationships between the tables before I add my subform? Fen

Hi, I have two tables. Atbl is project, Btbl are people. I want to have a sub-form on Atbl where I can select one or more people for project. Each project can have many people and people can be assigned to many projects. I for the life of me cannot figure out how to make this happen. What I...

Hi, I have a query in Access 2007. In 2003 I was able to use this code to export the query results into a DBF. Private Sub Command61_Click() Dim access As access.Application Set access = CurrentProject.Application access.DoCmd.OpenQuery "MASTER DBF QUERY" access.DoCmd.TransferDatabase acExport...

Hi, I am trying to solve this issue. Have been searching the forum for a solution but cannot seem to resolve. Reaching out for some insight. Looking for a one to many relationship between Table A and Table B. Table A has one Table B has many. I need B to be sequential as related to A. Table...

Hello, I am using some code I found on the forum to track changes to my DB. It works awesome however I was wondering if there is a way I can just write what changed in the mirror table versus the entire record. Here is the Before Update Code: Private Sub Form_BeforeUpdate(Cancel As...

Hi, Is it possible to activate something when a particular item is selected in a Dropdown list? Say I have 1,2,3 If user selects 1, something happens, if they select 2, something else happens and so on. Thanks. Fen How

Hi, Simple query with dates, I am tying to figure out how to when the query is run prompt the user for a date he wants the query to run on or select enter for all dates. Is this possible? Thanks. Fen How

Hi, Running this expression in a query: SeqNum: DCount("[Mineral_Tract_Number]","Query1","[Mineral_Tract_Number] = '" & [Mineral_Tract_Number] & "'")-DCount("[Mineral_Tract_Number]","Query1","[Mineral_Tract_Number] = '" & [Mineral_Tract_Number] & "' AND [MineralOwner_ID] > " &...

Hello, I am sure it is simple but I cannot seem to nail it. When I open my table, some of the text is left aligned and some is right alinged. How can I change this so all of my text is left aligned? Thanks. Fen How

Hello, Is is possible to save vaues from a multi-select listbox to a table? so that data comes in like this; 1,2,3,4 etc... Thanks. Fen How

Brilliant! Thanks so much. Fen How

Hi, is there anyway in a query to convert the -1 or 0 to a yes or no in the result? Data derived from a checkbox. Thanks. Fen How

Hi, I am using this in a query and it works great, however if I wanted to just run all records regardless of date is there anything I can add to this to give the option of "Hit Enter For All"? Thanks. Fen How Between [Enter Start Date] And [Enter End Date]

Hi, I cant get it to work. Would you mind taking a look at it if I send up the DB?

Thanks, that looks like it will work but seems complicated, is there an eaiser way? Thanks. Fen