Search results

Yeah I'll have a go now

Um it's formatted to General Date and in the field it will only ever have "##/##/####", so only date, no time.

Here's a snapshot of what I've done because it also shows my fields and things. I'm not very good at explaining things so this makes it easier

Thanks for the quick response. Well it didn't want to work :( The expression I used is "[InsActionDueDate]>=Date() And [InsActionDueDate]<=DateAdd("m",12,Date())" where InsActionDueDate is the fields from the query. Is this right, or should I use the column title?

I'm having a report run from a query, and I'm wondering if I can change the backing colour of certain dates on my report via its code. eg. If Date is between Date() and DateAdd("m", 6, Date()) Me.FieldDate.BackColour = Red I'd like to do it in code because the query is already asking for...

Try having a look at some of the threads I've started relating to dates as it seems I've needed similar help as you; a DCount could probably sort it and I've had responses regarding how to use these. Let me know if you find anything

Ah, you're looking too deeply into this. I explained the concept of the impulse line to give you an idea of what they were, however the process itself isn't of interest; it's the integrity of the line. I'm looking at it from a mechanical/material viewpoint, as opposed to a chemical/process...

I've attached a sample of my DB with a few records. If you could, could you look at it and give me a hand on applying the case-select statement to my DB? What I'm interested in doing is: Out of 4 categories, I'd like to be able to click a button from said category and that will load my...

Will this method sort them ascending or descending? Or do I also need to specify that? I've not used case-select before so a little run through would be appreciated. I'm gonna have a look at the help function to see if it can help me. Also, I noticed that this is in the report_open event...

I have a report which is based on a query and the query is based on form data. All is grand, but I would like to be able to sort the report differently depending on which button is clicked. Would this be easier to do in VBA or should I just make a couple reports and program it so that a...

Impulse lines are small bore pipework connected to larger piping, basically running a small sample away from the process, measuring a factor across it (velocity, pressure, level) then adding it back to the main stream. It's a primitive way of measuring characteristics of processes. At the...

Yes it's a database to categorise and structure a monitoring system for impulse lines on site. I can send you a sample of each of the sections of data so that you can compile a working sample, but this will have to be tomorrow as I've left work now?!

Sorry I only just noticed your response; much apologies for the delay. I've attached an entire copy of the database but I've removed the raw data. Can you do anything with this? I notice that the code's also been transferred so you can have a little rant about my shoddy programming skills :p...

Excellent! It seems to work great! I can't fully test it at the moment as this is more of a pre-emptive addition as my raw test data only contains "06", but eventually it will contain values such as 1-01, 4-04, 6-06 and I want to try to get this covered so it can be entered without a hitch.

I've a query where the parameters are entered by the user. I want the user to be able to return all values if the parameters are left blank and I can reach this with 'Like "*" & [...] & "*"' But the problem that I'm having is that the field of interest can have values like "1" and "01", so...

Only just got round to testing this as I only have Access in work, but the DCount is working great, thanks. I'd like to be able to make graphs from these textboxes, but they're not bound to any previous tables as they are record counts and not values. What'd be the best way to draw...

I've got a problem and I think i'm going to settle it with 3 queries... cue problem: A set of dates in a column can be in a range of 6 months from today's date, to 5 years from today's date, dependent on what's in its previous criteria. I would like to run a query that will look if the dates...

I'm structuring a monitoring process for a number of items in my workplace. As I said previously, I've had difficulty with getting the dates from a table because of my how I've gone about obtaining the results, where I've created 2 boxes and if a criteria is satisfied, it will select the...

It's the query which is in the sample database. I've deleted the report because I couldn't get it to work. If you try it, set the report up based on the query in the sample, and hopefully you'll get the same problem (I use 'hopefully' in quite the opposite way to usual) On my search form which...

Yes the initial dilemma has been dealt with, but a little problem I'm having now is with a report I'm getting to run from the query which I posted in the sample. It's asking me for criteria when I try to run the report, but when i just click "OK" to each of the questions it comes up with the...