Search results

I have limited experience in SQL so i built each query of the union query in the Access QBE and pasted the SQL code it provides.

Hello all, I am building a union query and it is not calculating an IIF statement correctly. I have three name fields, Last, First and Prefered, so if William prefers Bill then the prefered field states Bill, otherwise that field is left null. When i build a query for just the name this...

I seem to have found what was causing this, I had 5 controls with a tag of "Move" stacked with 5 controls that did not. Once i removed the stacked layout everything went smooth.

Hello, I have a form with a width of 19" that has several textboxes and command buttons that start Left = 1". the total width of all of these controls next to each other does not extend past a width of 9" and are all tagged "Move" I have a command button that when hit needs to move all the...

I think i found my mistake, i was setting the focus to a control on the next subform rather than the subform itself from the parent form. I can now set focus to each subform and then docmd.gotorecord,,acnew

Hello, I have a form with 5 subforms that all control different aspect of the same work order ID. What i am looking to do is hit a "new" button on the first subform and not only that subform goes to a new record but the other 4 subforms below it as well. I have tried new record on the 1st...

I did try that and i found my error was in putting it in the parent report rather than the Open of the subform report. It is not filtering correctly under: me.filter = Nz(path to Where string,"") me.filterOn = True had a nasty side effect though where it clears the selections on my listbox on...

Thanks pbaldy for the help, but the source object then filter did not work. One of the issues i am having is with changing the recordsource on open, because i cannot use a Where statement in the query itself. I have a standard frmFilters that loads the appropriate multi-value list box for the...

Hello all, I have a report i want to filter and then open in a subform. I can docmd.openreport "reportname: , acReportView,,strWhere just fine for a pop up report I can also use a command button to set sourceobject of my subform to the report but that method i am falling short on adding...

Hi all, I have a frmFormFilters that i use as a template as a subform for most of my forms. When it loads it Dlookups the parent form name in tblFormFilters and if a checkbox is true in the table it sets the visible property to true on the frmFormFilter for. (esentially tells the form holding...

Thanks CJ for the right direction, and the FYI on GROUP.

Hello all, I have seen similar post but none seem to answer my issue. I have a table tblDateGroups, with two field, [Group] (like This Week, Next Week, Last Month, etc) and [Code] that holds the code for criteria for each group in a query. I know the code is fine (like next week = Between...

thanks Plog, I think i was over thinking that. Maybe one day i can figure out how to do a delete query and just delete them weekly when i upload the table. this has been a great help for now.

Hello, I want to run a query on a table that holds all speed information for our trucks imported from a third party. Some of the speed alerts in that table are not correct so we set up a second table managed by the users to enter a speed exception. So if we know that Main St in Dallas TX...

Thank you Paul

Hi, I am trying to use a Like statement in a VBA dlookup, as some of the fields in a third party db i cannot manage are variations of fields in a table i need. i currently have: Me.Clinic.Value = DLookup("[ID]", "dbo_Clinics", "[Name] = Like '%' &...

Thank you both for the help, after reading up a little more on Union queries, it worked perfectly, exactly what i was looking for.

Jdraw, there are no relationships between the three tables, the are all independent.

Thanks MarkK, i think i know what you are getting at. this is a third party db i have a read only ODBC connection to. would there be a way to "make" my own table that combines all three of the tables i am connected to?

I have a few different tables that hold somewhat like info. A tblClinics has ClinicName address, city, state, zip, a tblPatient, LastName, First, all the address fields, tblDrivers, LastName, FirstName all the address fields. What i am hoping for is to have a txtbox that can search all the field...