rich1838
Last Activity: Aug 2 '15, 04:55 PM
Joined: Dec 21 '12
Location:
-
I just realized this is on a subform and that has no OnCurrent. The code was placed in the RaceEntryForm which has the child FieldData Subform. All the tables and fields are correct -
Placed it in OnCurrent and get Compile Error. Method of Data Member not found. TrainerLookup is my control box name
...Code:Option Compare Database Private Sub Form_Current() Dim sSQL As String sSQL = sSQL & "SELECT TrainerData.ID, TrainerData.Trainer, TrainerData.Track " sSQL = sSQL & " FROM TrainerData " sSQL = sSQL & " WHERE TrainerData.Track=[Forms]![RaceEntryForm]![Track]Leave a comment:
-
Stuck again! The search works great, however I now have a problem where when I go to the next record, the last chosen item is in the field instead of going blank.Leave a comment:
-
Worked like a champ. Thanks for the help!Leave a comment:
-
May be simple but just to confirm. Is this going in the on change or AfterUpdate property. Reading post not sureLeave a comment:
-
I have tried to implement this and it does not appear to be working. I will attach the code from the query that the combo box uses. it has a filter built in already as trainers data is track specific therefore their name may appear multiple times in the table.
Code:SELECT TrainerData.ID, TrainerData.Trainer, TrainerData.Track FROM TrainerData WHERE (((TrainerData.Track)=[Forms]![RaceEntryForm]![Track]));
Leave a comment:
-
filtering a listbox
I have searched and not found an answer to my question so I am posting.
I have a table named FieldData with a lookup field that gets data from another table TrainerInfo that full names in a single field (John Q. Public, Sr.) and it works great.
What I would like to know is when start to type the name "John", can the dropdown list filter names only with John in the field. Also, is there a way (similiar to searching... -
Search Form to input query criteria Stopped working
I have a database with a search form that has been working flawlessly and now has completely stopped. The Form has 3 fields (a Date field, a combobox field, and a text field).
As I said, it worked flawlessly to return queries until this morning. I attempted to delete and re enter the criteria in one of the queries it fetches with no luck. Any IDeas of how or why this would just stop working? -
DLookup function with no action or errors
I have a database to manage a company with 4 divisions. A table [employee] has a related form with the employees title. In order to break down employees by division, I created a table [titleconversion] where fields have the [Title] and [Division] and [EmploymentStatu s]
In the on the form [employees]![Title] i am using an afterupdate DLookup code to place [Division] and [EmploymentStatu s] based on the entry. My problem is NOTHING is...Last edited by zmbd; Jun 20 '13, 02:17 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql - Please read the FAQ}] -
OK. How would you do that, I keep getting The expression you entered has a function containing the wrong number of arguments.
LastName1: Left([Name],InStr([Name],",")-1, Left([Name],InStr([Name]," ")-1))Leave a comment:
-
LastName1: Left([Name],InStr([Name],",")-1)
Same query
LastNamedone: Left([LastName1],InStr([LastName1]," ")-1) "Invalid Cell Call Error"
Created New Query
LastNamedone: Left([LastName1],InStr([LastName1]," ")-1)
Result-#Funct!Leave a comment:
-
I have an access 2010 database where I import two tables from excel into 2 tables the database from a 3rd party. The first table is an employee list with demographic information and the fields are Last, First, Title, Address, Address 2, City, State, Zip, Telephone, and Hire Date. A new list is sent monthly, so Once the first set of records is in the table, the next step is an update query which adds new employees, updates former employees, as well...Leave a comment:
-
Unfortunately that did not work. When I do the initial split, I get the single names are ok but the ones with titles are still attached. When I split again by space, the single names are omitted and only the ones with tiles are present.Leave a comment:
-
Splitting fields to last and First Name
I have a database where information is imported from another source. The other party sends 2 files that are imported. In the first file, they send employee information such as name, address, etc. The other file is automatic deductions that an employee makes monthly. I need to create a query that combines the two which I have no issue with. Here is the problem. The first file (Table) the name is split into 2 fields, and is just First and Last names... -
Thank you for the assistanceLeave a comment:
-
Date results show 12/31/1899
I have two related tables and each have a Date field with a default value =Date(). When I create a form with a subform, the subform shows a value of 12/31/1899. When the forms or tables are opened independently, the dates are appropriate. Any Ideas? -
Access Database "Stopped Working"
while finishing up my database, suddenly the dreaded "Microsoft Access has stopped working" with the scolling bar below in the box appeared and access restarted. This keeps happening whenever I reopen (either original or backup) I noticed the files were renamed (C:Database21[Conflict] and C:Database21[Conflict]_Backup). Prior to the event everything was working fine and tested. It all started when I clicked a previously working drop down... -
Using a form to query a range of dates for a web access database
I have an access DB that uses a form to query a range of dates in order to provide results. In the critereia for the query date field, I have Between [Forms]![reportcenter]![Text46] And [Forms]![reportcenter]![Text48]. This works perfectly.
I am now moving this to a web access database. I understand that web queries cannot use forms, so in a macro I entered in the where condition [completeduesque ry]![Pay Date]>= [Text46] <= [Text48.... -
It worked. Thanks Neopa...Leave a comment:
-
The expression after update you entered as the event property setting produced the following error:Syntax Error.
I tried your changes and got error 3075 syntax error...Leave a comment:
No activity results to display
Leave a comment: