Search results

Ok so you want when someone hits enter when they are in the text box that the form closes? First are you sure that the user will never want to cancel when they are in the text box and click enter? If that is what you want then in the properties of the text box go to the events and in the On...

Wayne,...Thanks but it doesn't seem to work....When I ran the form, the query was blank. Right now the tables are blank with the exception of the Staff table. I put in a breakpoint to make sure that the getCurrentIncidentNum had the incident number and it worked. I changed the...

Sorry, I have a table (tblStaff)that is a master table of all staff, and a table (tblIncident) that is a master table of all incidents. And then a table (tblIncidentStaff) that has an entry for each Staff involved in an incident with the particulars of the incident.

hmm. It didn't seem to work the table came back blank I did edit the query a bit as it seemed a little off. Here is what I used SELECT T1.* FROM tblStaff T1 LEFT JOIN tblIncident T2 ON T1.id = T2.Id WHERE T2.Id Is Null; Because the fields were labled tblStaff.Id and tblIncidents.Id. I had a...

I have a db with a table for staff (tblStaff) and a table for incidents (tblIncident) I have a form for creating a new incident. After you create the incident, you can add a staff member(s) that were involved in the incident. What I want is a combobox that has the list of staff in tblStaff but...

That was it....I have had a quote issue in the past.....How do you know when to use Single, double quotes, etc??? Thanks for the quick response!!!

I have a form that has a combo box. I want to use the combo box selection to populate the form. The problem seems to be that the Field that the combo box is using is in the form of A-12345. One letter, a hyphen and 5 numbers. I have tried a few different methods that have worked in the past but...

Is the textbox bound to your table? If so, check the table for the field length.

I think my problem is that I want the combo box to do something it can't...I want the combo box to list all the AKA's for the CDC number on the selected form and that the user can add additional AKA's from the same form...I think I might have to use a list box to display the AKA's and a text box...

NO PROBLEM....You are a great asset and if it takes you a while, I won't complain....I am glad someone as knowlegeable as you is around!!!! I just found something!!!! hmmm...well I guess it is the combobox...I stumbled upon the combo box and if I click the arrow, the info is at the bottom but...

Here is the file....I used a different zip program...I hope it is compatible with what you have. Select any of the names on the form (double click the name or select a name and hit the select button) and then the form in question pops up....the combo box is cmbAKA

What is really strange, is if while the form is open, I go to the properties of the combobox and then the row source for the data and look at the query from the data sheet view the query works....go figure...it seems like it just doesnt like being in a form....I guess I could always add an ID...

NO, I didn't get it working so you don't know how to reference a control with test data in a query??? It is wierd because from the immediate window the query seems to work fine!

ID is text...And as usual you are right on top of it. I tried to enclose [Forms]![frmIntelInfo]![txtID] in single quotes and double quotes....but I am sure you know the trick....is there any references for when to use single or double quotes and where? Thanks for your assistance.

I have a form (frmIntelInfo) that has a combo box that I want to populate with data from a table (tblAKA) that is filtered by the text in a textbox (txtID) that is on the form. The combo box does not populate with anything. I have the properties for the combo box to populate via the query...

Thanks a bunch.....I got it working with your help!!!

I have two tables (tblRoster and tblAKA) tblRoster has the specifics on each person (ID#(unique identifier) Name, Address, Phone) tblAKA has the ID# and nicknames, sometimes more than one nickname for a person. I need a query that will join the two tables BUT I only want one entry for each...

Thanks, I missed that....I searched the forum but to no avail!

I have a form (frmSearch) with a couple of listboxes (lstSearchName, lstSearchNickname).When the user double clicks an item in the listbox a new form opens up(frmInfo) that is populated by a query (qryRoster). From what I have found, is that you can not use a variable in a query but can...

I guess I am a little rusty, I have been workin on a different platform....that would work. Thanks And Damn...you are quick!