Search results

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"

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...

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...

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

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'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...

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...

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...

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...

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 have an add form which is supposed to take the info input into a form and then add it to an existing table. Here is the code that I've used: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tbl06ButamerAllLines", dbOpenDynaset, dbSeeChanges) With rs .Edit rs!UniqueID = Me.txtID...

Can I use a query to make a table that will display values from text boxes on a form? I understand how to make the table so that each value will be displayed in a seperate column, but can I get 4 different text boxes to be displayed in different rows (in the same column)?

I have a form which outputs multiple date values, dependent on previous criteria. Is there a way that I can use a textbox to show the date of whichever of these dates is closest to the present day? i.e. I have 4 due dates (6/30/2012, 6/30/2013, 6/30/2014, 6/30/2015) and I want the text box...

Ok I can't imagine this being hard. I want a checkbox to be "checked" when a date is entered into a textbox, so, "If .. = True, checkbox = True" or such and such What code do I need for this?

I have a form which pulls data from another form and I need to get that data to be added to a seperate table. I have a button which will run this coding, but what is the code that i need to use to do this? I saw a similar thread to this about creating a form from a table but I cannot do that...

I have a form which somebody will use to populate a table/report, but I want to make sure that all required boxes have data entered before the table/report is populated with the form's info. I was thinking I could use the isNull but I'm not sure where I should put it or how. I have a button...

So I have a form which has a combo box linked to another bunch of text boxes. When I select a piece of info from the combo box, the other text boxes are populated with the information from the table regarding the selection. There isn't a problem with the boxes being populated, but whatever...

I have a bunch of text boxes in a form which show a number according to a choice, which is then fed into a text box bound to a sum of these boxes. I want to have another text box display a string of text, dependent on the sum eg. display "message" when sum > value. Now I think I can do this...

I've made a form which is based upon multiple queries. Each query is linked to the form using combo boxes, and essentially what happens is I can select an option and a number is output. I've done this using the AfterUpdate event and it all runs nicely but what I would like to do now is take...

I'm new to Access (2007) so i'm going a very long-winded way about making a formulae sheet. Basically I've written a set of formulae out in Excel and want to transfer this so that it'll work in Access. I've written a form which has various combo boxes and a seperate query which references...