Search results

That's a very in depth reply and I appreciate the hasty response. I instead decided to use a load of text boxes with their control sources as DCounts pretty much saying any value that isn't "CAT D", or "Complete" is an MWO number. Was tedious but it's doing the job nicely and I know I can...

Could I perhaps set the DCount to search for a Double rather than specific details?

What it is is a work order number. Originally the work order is given a priority ("CAT D" in this case) but then once the work order has been addressed it becomes an "MWO number". The MWO number consists of the year [in 4 digits] followed by 6 numbers. I considered using a date string with 6...

Can you do a DCount for 10 digit number? I have a query which could have results either of text or a number. I've got the text sorted, but is there a way I can do, say: =DCount("*","[qryName],"ColumnName='##########'") or maybe something to say "does not = text"

Solved this one if anybody's interested; used this code: If Me.txtMatDate < Me.txtInsDate Then Me.txtNewDate = Me.txtMatDate ElseIf Me.txtMatDate < Me.txtTraceDate Then Me.txtNewDate = Me.txtMatDate ElseIf Me.txtMatDate < Me.txtTraceDate Then Me.txtNewDate =...

Sorted. If you're interested, I used ("*", "[qryName]", "IsNull(columnName)=False")

Can I get some help here: I would like to count the number of records in a query containing non-specific data (ie. "*") but I can't seem to get any values. If I use a DCount on a form and use defined criteria then I get the record count, but I just want to count the number of records with...

Thanks for the help Bob. It didn't find any bugs so instead I used a previous database and redid the lost work. It doesn't seem to be playing up. Hopefully I haven't just masked the problem and it won't come back to bite me in the ass

I don't know why but my database was all working fine and then I saved, closed and reopened, and now on one of the forms it keeps coming up with the message: "The expression On Current you entered as the event property setting produced the following error: Return without GoSub." This message...

By the way this is what I'm using on my form to check for the records: =DCount("*","[qryNotActioned]","UniqueID='*'") I'm using the asterisk in the inverted commas because I want the count of any record with data in this field

Quick question. How can I count the number of records in a query, on a form? Basically I've a query set up and I want to show, on a preform of the query, how many records are present

Ok I think I avoided it; I just recreated the original report with the same name and it seems that everything's in order again. I got out of this one ok it seems (well, it does at the moment) but if anyone's had a problem like this could you post a response as I don't like near misses like...

I'm in the midst of a meltdown. Yesterday I changed the name of a report and returning to my work today it seems that my database will barely function. The report is opened through various lines of code based in forms but it doesn't have a massive part to do with my database. Anyway, almost...

I just had a closer look at your .jpg and I think I understand it a bit better now. At the start of my code, could I dimension a string as a "button click" and then assign buttons to the dim'd value? ie. Dim InsButtonClick As ButtonClick InsButtonClick = button1, button2, button3 or...

Thanks for taking time to respond, I understand that you're busy at the moment and I very much appreciate it. Yes that looks brilliant! Whereas on yours you have the user select an option button, would I be able to use something similar to this, where, upon clicking a button, the relevant...

I found this: http://support.microsoft.com/kb/209857 Could I use something like this to sort dates? Sorry for the lack of response but I've been quite stubborn with my work and don't want to go back and change the layup of my things; still, I don't understand your last suggestion with the...

Still no feedback on the initial question. Any suggestions? And Gemma I don't really understand what you're suggesting; would that use similar coding to the coding i'm asking for? Because if so, could you put a shortened eg. or link to something like it? Sorry it's just that I'm close to...

I've already posted a similar thread to this but it didn't help so I'm reopening it to try to get an answer. The response I had previously was This method I don't understand because I don't know what I should use as "GroupLevel", "txtGroup" and the "= "CarType"" etc. As I have a number of...

That's ok, thanks for your help anyway

Here. A lot of the data has been removed, but the records needed are still present