Search results

Month function Returns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year. Syntax Month(date) look into it.

I think you can use something involving month(txtdate) to use the month part of a txtdate control.

This should do it.

you need an ID autonumber field (easiest) in each of the subordinate tables (customers, etc.) then in your invoice table, you need a field to associate each invoice with a customer. make a combo. it's rowsource should include both the ID column and whatever field you want to display to choose...

try this.... SELECT ContractNumber FROM tblContract WHERE month(ContractStartDate) = 11 AND month(ContractEndDate) = 12;

hm...hadn't thought of that. i suppose i'm the one missing something. I'll give that a try.

My form's recordsource is a query. the single form display shows one record (one job) at a time, and a subform displays invoice dates and amounts for that job. i want a text box to display the sum of those invoice amounts to date. tblinvs contains invoice dates, amounts, and the job they're...

I need a subquery to do what this query does: SELECT tblInvs.InvJob, Sum(tblInvs.InvAmt) AS SumOfInvAmt FROM tblInvs GROUP BY tblInvs.InvJob; It groups invoice amounts by job and sums the invoices for each one. the value will be shown on a form, so i need this to be in the recordsource, and i...

ahem....bump

nudge.....

I'm having the same problems. here's my description of it: on my 'search psage', i have a combobox (cbokwsrch) that i'm using to choose a range of values for a field (kw) in my table (input). the combo is liked to a table (tblKw) that has an autonumber index (column 0), and a column that lists...

they're more commonly called combo boxes here, and choosing from the list is their standard use. to add a new value to the list, you have to use the notinlist parameter. try searching for combo, combobox, or notinlist and you'll find lots of discussions.

would it be possible to open a new form that only has the backup button, close the original form, automatically press the backup button, close the new form, and reopen the original? how would i code this?

I'm trying to display the date that the back end database was last backed up on the same form as a backup-button. unfortunately, you can't use the backup command if a bound form is open, and to show the last date, the form needs to be bound to my backupdate table. here's my backup code if it...

I'm still pretty new at this, but it sounds like your database doesn't have the best design. i'd say search for 'normalization' or 1st normal form to find out how to make more efficient tables.... or you could make a table that contains a column for table name, a column for road number, etc to...

try this: Between fValSrchL([forms]![frmRetailerQuery]![txtMinCaseSales]) And fValSrchU([forms]![frmRetailerQuery]![txtMaxCaseSales]) and copy: Public Function fValSrchL(vValSrchL As Variant) If IsNull(vValSrchL) Or vValSrchL = "" Then fValSrchL = 0 Else fValSrchL =...

I never got the date comparisons to work, so what i did was use datediff and choose the status based on the sign of datediff. negative means late. works great.

Still not working...... it won't decide either way with: If Me.dtQuote_Date > Me.dtQuote_Due_Date Then and If Me.dtQuote_Date < Me.dtQuote_Due_Date Then i put in a breakpoint and stepped through it, and it skips both. it doesn't seem to understand < and > with dates. here's my full code...

in the design view for the form, right-click on the small square in the top left corner, and choose properties. pick the Event tab, pick the 'on open' field, click the three dots to the right of it, choose code builder, and paste that function in between the "Private......." and "End Sub".

DoCmd.RunCommand acCmdRecordsGoToLast takes you to the last record. is that what you need?