Search results

Greetings! I have a form with one unbound text box and an unbound list box. The listbox has a query as the row source. the query has a field (SSN) that is a number field. it drops leading zeros. (I cant change it to a text field, it is linked to an oracle database.) The text field is used as...

Greetings, I have a query I want to run on the ON OPEN event of a form. I want it to run only once a day. I have the following code on the ON OPEN event Private Sub Form_Open(Cancel As Integer) Dim update As String update = "Select GDCSearch.LastUpdate from GDCSearch " If update < Date() Then...

Greetings, I've been messing around with this for a few weeks and need some help. I have a listbox and on the dblclick event it opens another form and displays a form(participant) that has three subforms. One displays information in a datasheet view (RequestSubform), another displays the...

Greetings, I have a DB witha subform listing REQUESTS attached to a PERSON. Person is master record, Request is child record. There are many records to the child, one master. The subform is displayed in datasheet view. I want to be able to click on one of the child records in the subform and...

Greetings, I found an example of a search example on this forum a few months ago an have been trying to build something similar but have a few bugs. I have a search form at the start of the application, a txtSearch field to type the text to search, below is an unbound field attached to a query...

I have a report set up as a letter for mailing purposes. in the letter i have a subform listing names, amounts, ect. it is setup in datasheet view. the problem i have is the more records in the subform it causes the text to display over top of the main reports text boxes that display verbage on...

Greetings, I have a database which is heavily relied on to provide information running a business. Their are 20-30 people in it at a time inputting information, creating documents ect... Our server has gone down twice within the last week and information had to be restored from out IT dept...

Greetings, I'm having a problem getting the syntax correct when referring to a field on a page/tab. The database is set up with 3 pages, there is a main page(frmMain) and two other pages with subforms(frmLetter, frmVoid) linked to the main form. On the subform(frmVoid) in the default value...

Greetings, I have a database and need to put a button/combo box/???? that will reference another database and reference a form within that DB. I also need it to filter to a certain record on the form(Group field). I was playing around with the RunApp in a macro but dont know what I'm doing...

I have a user interface form (frmCP)that a report is generated from(rptCP). the form has many option buttons that are option groups of yes or no, it also has text boxes and date fields. The form is attached to a table(tblCP). When the user inputs the data, the report doesnt show the changes...

I have a form with check boxes (yes=1 and no=2) and also option buttons(values -1 and 0). I built a report from the table built from the form. The report has all bound fields from the tbl. The report has check boxes and I want to show them as 'checked' if the value is 1 for the y/n fields and...

I have a form that displays 1000 records. On the form is an option button "do not Contact". when it is toggled on (-1) I want a label to be visible(properties are set to visible=no). Here is my code Private Sub Option369_Click() If DoNotCommWithGrp.Value = -1 Then Me.DoNotContactLbl.Visible =...

Greetings, I have a form(frmMainContacts) that has a field "notes". The form is attached to a table(tblMainContacts). I have tabs that have subforms,frmCalls set up in datasheet view. When the "notes" field is updated on the main form, I want it to send the note to the subform on a new line...

Greetings, I search this forum for a search feature for subforms. I found one and attempted to copy the code and apply to my database. I getting two error messages and stumped on how to fix. I want to be able to search by a Participant Name, SSN or Request ID. The request ID is in the subform...

I have a database with several tabs named "Participant" and "Participant calls". The tab named Participant is the main form, on the form is a field "Participant Notes". Heres the fun part...my senior executive explain this in a presentation to the users but I have not idea how to build it. But...

I'm building a db and have questions on the approach/designs. I have a form, user inputs a SSN, it runs a query that returns several lines of information. I want to be able to select ONE record, have it write to a table named "groups" that is a sub form. Any suggestions on how to select the one...

Does anyone know of a way of having an "Audit" trail for changes made to a database?

I have a database with a field named "results" with 3 options of closed, open or pending. I also have a field name "closed reasons" which are toggle buttons with 5 options. I want to be able to update the "results" field to closed when one of the closed options is selected. Also, if the results...

I'm want to create a field in a table based off of another field and add 14 days. Some of the records are blank. I tried to put the following syntax in the default value field of the calculated field. [DateMailed]+14 this didnt work I also tried an if statment Iff ([DateMailed]not null...

I have a form with three fields on it, Two of the field are used to match fields on a query to pull information from a datawarehouse then run a report. The third field is a field I want to populate on the report but is not in the Datawarehouse. How do you put a field on a query that does not...