Search results

make sure that forms![frmPelAdd]![employeenumber] has a value in it.

Runtime error, cannot use Ucase() in query expression ? Ucase is part of access and has worked from day 1, then recently stopped.... The only thing I've found is that if you compact the datbase on a machine that has Excel 97, then use it on a machine that has Excel 2000 or higher, the error...

I did this a while back: 'Checks to see if there is another instance of OSR+ open 'If Return value is false then there is an instance already open 'Written by Chris O'Donoghue 22/11/00 Dim blnSwitch As Boolean Dim strDBCaption As String Dim lnghWndApp As Long Dim lnghWndDB As Long Const...

how about a function that does the checking for you before the record is saved or when the data is entered ? much easier to maintain, more powerful and very easy to implement

form level validation is the way to go, but microsoft put the one-off in there to help out if you had used table level validation, nothing more. If the design hadn't changed, then I guess you wouldn't have found this out ?? A good quote that may be applied here: "Measure twice, cut once" :)

not sure what you mean mate, both the report and the subreport are based on queries, and both of them look at the date worked, but one looks at them joined to sales and one doesn't

better to use a toggle button and check if it's visible property is true or false before changing it, just a GUI thing :)

main report part has days that sales were made, based on sales date (many side) subreport has days worked regardless of sales (one side) I want to make the days worked without sales bold the subreport is linked to the main report via an employee id, not dates of any kind

your code is ok, just put it in the format event for whichever section of the report the controls are on

you are right, that is the relationship between the two, but the report has to be backwards (it was asked for like that) normally, I'd be able to do this without too much hassle, but I've tried it about 4 different ways and can't get it to work

To get the three digit numbers: Simply put a criteria on the number field in your query to say <1000 To return the highest number: Sort the field descending, then in the properties for the query, simply change the top predicate to 1 and it will return the first number only

a more efficient way would be to use Is Null in the the query like this: SELECT Table_1.id, Table_1.quantity FROM Table_1 LEFT JOIN Table_2 ON Table_1.ID = Table_2.ID WHERE Table_2.quantity IS NULL

don't forget to do the else part as well, to disable it

In the code to open the form do the following: to view it: use the acReadOnly option to add new records only use the acAdd option the default is acEdit you can do the same from a switchboard as well by choosing the option from the list of actions (open in add mode etc)

You could try this as well: With rst .MoveLast .Movefirst While Not .EOF If .Fields("dblSupQty") = 0 Then .Delete .MoveNext End If Wend End With

try calling the subform by it's name instead of a control on the main form something like forms("subform").form.recordsource

if it's access 2000 or later, you can use conditional formatting if it's 97, you might want to try the format event for whichever section that it's in (detail, footer etc)

is there no-one that can help ?

I know you can't do this via conditional formatting and you have to use some code to do it in the format event.... BUT I'm having problems with one at the moment (it's pretty complex) Main report shows days that sales were made by someone sub report linked via employee id shows days that were...