Search results

I have a list box (created with the wizard using the option "Find a record on my form based on the value I select in my list box". Next to the list box I have a button created with the wizard that does the '"add new record" action. The problem is that when I add a new record, the new record...

I am trying to get a button to delete the current record using the command: DoCmd.RunCommand acCmdDeleteRecord but nothing happens when it runs. I am sure the code is running because I have set a msgbox to come up after it in the click event and it comes up. If I use the button wizard to...

I need to run an append query when I open my db that will look at a date in the records and copy the records when date() >= [PeriodEndDate] and some other criteria. I have the append query working perfectly. But the records still need to have some code run on them to set up fields in the new...

On a form I have a combo where a month is entered. It shows the month names in column one, but it is bound to column two where each month's corresponding number is, ie Jan=1, Feb=2, etc. So selecting April returns 4. Also on the form I have a text box where a number is entered and used as the...

Is there a way to find out the number of Wednesdays between two given dates? Thank you.

I'm trying to drop decimals and zeros when they're not needed. For instance, if I type 3 I'd like to show as 3 instead of 3.00, and if I type 3.5 I'd like it to show 3.5 instead of 3.50. I can't find how to do this but surely it can be done. Thanks.

I use a Value List for options in a combo box but I don't want exactly what is selected to be written to the record. I need each selection of the combo box to correspond to another value that should be written to the record. For example: The combo options from the value list are Day(s), Week(s)...

I have a db where each record is a certain task to be done. Each record includes the date the task should be completed. Some of the tasks are one time only but some are recurring. I have been having to create a new record for every task even the recurring ones, but I have decided to try to...

I need help with a crosstab query ( :eek: ). I would like the column headings to be the last 6 months, the row headings to be billers, and the data in the middle to be both the date that a payment was made (falling within the month headings) and also the amount paid in that payment. Sometimes...

I use a db for my checkbook register. My current job pays twice a month, on the 1st and the 15th. I use some code that allows only items dated before my next payday to be figured into my balance, so that anything dated past my next payday isn't figured into the balance until that payday gets...

I use a db for my checkbook register. My current job pays twice a month, on the 1st and the 15th. I use some code that allows only items dated before my next payday to be figured into my balance, so that anything dated past my next payday isn't figured into the balance until that payday gets...

I have a report that opens with a button on a form and I'd like to have the report open to the last page. I tried using sendkeys and it works when I manually open the report from Reports on the msaccess screen, but when I use the button on the form the report opens to the first page. It looks...

For a field on a report, I'm trying to use an If/Then statement to set the Control Source depending on the day of the month. I need one Control Source for days 1-14 and another for 15-31. To do this I put this into the report's open event: If (Day(date) < 15) Then here are the control source...

I have a table that contains transaction info including the date of the trans and the date of the order. Some orders do not have a transaction date yet. I'd like to have a report that shows a total dollar amount on all the orders and also shows the total dollar amount of orders that do have a...

Is there a way to make a field on a report visible or not depending on the current date?

I have a table of transactions, some with past dates, some dated the current date, and some dated in the near future. On a report, I'm looking for a way to get four different sums using the transactions in the table, each sum based on the dates of the transactions. I need a sum of transactions...

I have a table of checking transactions. Some are past, some from today, and some are dated with future dates (such as recurring payments). Is there a way to set up a query that will exclude transactions that occur after upcoming paydays (1st and 15th) dynamically? For instance, if I have a...

I have a table of checking transactions. Some are past, some from today, and some are dated with future dates (such as recurring payments). Is there a way to set up a query that will exclude transactions that occur after upcoming paydays (1st and 15th) dynamically? For instance, if I have a...

I have a db that is a checkbook register. I use a field in each transaction record to tell whether the transaction is current or is a future transaction (if it is in the future then it doesn't yet affect my balance). For instance, if the item is not scheduled to be paid for two weeks (I...

In my Checkbook db, I'd like to have a report where one field is the sum of all debit transactions in a table and another field that is the sum of only the transactions that haven't cleared (they have no post date in their record). How can I do this?