Search results

What? Explain this again, it doesnt seem to make sense...

=DateAdd("m",+30,[StartDate])

Can you post a sample db for this problem. I saw your post from the other site...

A form is a form, if all controls are on this tab form then all you need is an event that triggers when the tab is selected that tells the control to get the value of the control on the other page.

Ok, so they dup a record.... How does the user know which value to plug into that field(the Id field)? Does that field have an input mask? Why couldnt you delete the contents of that field after the dup takes place and force the user to enter the new record ID before saving?

Well, yes and no. Lets say you have the users logon ID, and a tbl that has something with IDs and a tbl that shows he/she finished the task. Using a query or two one can find out if the last or any task has been completed by the logged on user and then have the computers clock to determine if...

I just thru you expression into an unbound textbox and it displayed 12/7/2004

That didnt work.... I tried this in a query and it works doing the the math to add the 6 mos first then subtracting a day from that. Gotta be a single way to do this though... SELECT DateAdd("m",+6,[StartDate]) AS Test, tblTeamMembers.StartDate, tblTeamMembers.TeamID, DateAdd("d",-1,[Test]) AS...

Not tested but may work. =DateAdd("m", +6, "d" -1[StartDate])

While in design mode, theres a little hand holding a sheet of paper(properties)...on the tool bar... Click it then click the data tab, theres a arrow next to the entry for record source... change it to your qry name. Then theres a icon on the tool bar that looks like a sheet of paper only...

Sorry about the answer I gave you... I read too fast and thought I had what you asked. In a query this will produce the month, the year and the month + year SELECT Format([myDate],"mm") AS [Month], Format([myDate],"yy") AS [Year], Format([myDate],"mm/yy") AS [Both] FROM tblDates;

Well, I guess you could use MID on that field into another by using: Returns a specific number of characters from a text string starting at the position you specify. Syntax NewMonth:MID(text,start_num,num_chars) Text is the text string from which you want to extract the characters...

If the company ID is on the form somewhere then all you have to do is include a where clause to the control where it equals it. SELECT Contactpersons.Name FROM Contactpersons WHERE Contactperson.CompanyID = Forms!MyForm!ControlName

If IsNull(Forms!frmLogEntry!Text71) Then Forms!frmLogEntry!Text71 = Me.Text535

Heres a sample

You need a where clause for the 2nd cbo WHERE FieldName Not In ([Forms]![FormName]![ComboBoxOne])

I take that back. I just used the OnMouse Move event to both highlight the text in the cbo and made the foreground of a text box change. So, the answer is yes! It would take a series of if statements to do this as far as highlighting the other text boxes as you want.

I dont think moving the mouse over items in a cbo can have any sort of code that will trigger or can trigger something else. If there is I want to see this in action also!

Here is a sample with 1 table and 4 queries. It does not allow for changing values in a query though... I do believe this can be done with unbound controls on a form using no table and queries, just code...

I built a quick table using your characters to try this... Only B, F, N and a ID field. To get "R" I used this in a query: SELECT ((1/[N])+([F]/1200))*[B] AS 1, Table1.ID FROM Table1; To get "B" I used this: SELECT R.ID, Table1.F, Table1.N, R.[1], [1]/((1/[N])+([F]/1200)) AS 2 FROM Table1...