Search results

You could place the field containing the Dollar sign up against the field with the numbers. right align the dollar sign field then left align your number field and they will appear to be right next to each other

Have a look at these previous posts (hope they help) Posted By Len Boorman Suspect that when security was set on a database the System.mdw file was used. This you never do. Alternatively You have opened a secured database and joined the appropriate workgroup. When closeing you have not...

Have a look at the amendments to your database (attached) Hope this is what you are after

The only problem with using a append query is the end use will get a box that states you are appending so many records If you type the following the above messages will not appear DoCmd.SetWarnings = False Run your query DoCmd.SetWarnings = true

I am assuming that your database is a secured dbase (with a username and password needed to login) this being the case. Prior to callin or opening any forms you can run a query to select from your table (holding what can and can't be opened using currentuser() in the criteria section of the...

Place the following code in the forms on open or on load Dim 2day as integer checkbox.enabled = false 2day = format(date(),"d") Disable checkbox on form open or close if 2day = 5 or 2day = 6 then checkbox.enabled = true end if (5 = friday 6 = saturday)

You could create a new query that references the query that the first report is based on and also references the query the second report is based on (don't forget to link the queries. You should now be able to manipulate the data to your requirements

Not sure if this is what you want but here goes aDay = Format(Date, "dd") amonth = Format(Date, "mm") ayear = Format(Date, "yyyy") ayear = ayear + 1 End If TxtDateBack = aDay & "/" & amonth & "/" & ayear

Try something loke this Dim Con As ADODB.Connection Dim Rst As ADODB.Recordset Set Rst = Con.Execute("Exec Yourstoredprocedure") Rst.Close Con.Close

Start = DLookup("Date_Commenced", "tblEnquiries", "[ID]=" & Me.lstResults.Value) If IsNull(Start) Then Try this: Start = Nz(DLookup("Date_Commenced", "tblEnquiries","[ID]=" & Me.lstResults.Value), "") If Start = "" Then

There is a limit but I think it depends on the amount of data in each sub report. I have just created a report with ten sub reports each having omly one field and it works. I have in the past fallen foul of the limit if the sub reports contain more data the limit it stopped me at was 7

Try This NZ([ChargesThisStatementPeriod],0) + NZ([CreditsThisStatementPeriod],0)

select the customer field then right click select properties then select the format tab then set hide duplicates to yes

one solution (not pretty) would be when you click on your button to close the form and then open it again

I would create a form with either a text box or combo box (combo box contains a list of known parameters) or just type into the text box In your query place the following in the criteria section forms![Newform]![field name] create a button on the new form that calls your query

In the combo box properties select the data tab then set limit to list to yes as soon as you tab of the combo box you will get an error message

in the field section type CallNum:iif([CalledNumber] Like "*?*",[CalledNumber]=Mid([CalledNumber],2),[CalledNumber])

if([CalledNumber] Like "*?*",[CalledNumber]=Mid([CalledNumber],2)) Try this if([CalledNumber] Like "*?*",[CalledNumber]=Mid([CalledNumber],2),[CalledNumber])

You could try importing the excel spreadsheet into your database File , get external data , import

I wouldn't recommend it but Look at the on click event of your button and use the save command used there by putting it in the on click event of your check box