Search results

Not sure if help is still required but you don't need to over complicate it. All you really need to do is open up your selection criteria, and providing you are capturing the date for each record, select this field and choose = lastfullmonth That should do the job.

did you create the parameter and add that into the equation? This does work if executed correctly. Follow the instructions step by step remembering to set the parameter field to the same type as your amt contributed field. Post the code you have got on each suppressed field and let me know how...

Off the top of my head, I think it may be because your form had lost it's focus. Maybe by adding some code to set focus back to this form, then for good measure do a me.refresh me.requery then try the button again. you may also want to slip in form_yourform.filteron = true if that doesn't...

not sure if you are still looking at this post 3jmj but what you want to do is filter the records retrieved by going into your select expert and choosing new, job no field, then formula from the drop down and entering something similar to not isnull({jobno}) in the box opposite.

In this case you do not need a report filter. What you actually need is to suppress the other 2 fields where it meets your condition. You will first need to create a parameter field and set the type to match your filter field. Save it. In design view, right click on the 1st of the 2 fields and...

Excel 2003 Outlook 2003

Hi all, I am struggling with this. I have a seached but not found the answer anywhere. I have a simple excel sheet with a macro that emails cell values to named recipients. I wanted to glam up the email a bit by adding a header image, but I can't figure out how to do this. I figured that I...

if you have taken my code verbatim, then you probably won't be able to prompt on it as it is using currentdate. currentdate has no attachement to your database records, therefore cannot be used to return particular records from your db. However, if you replace currentdate with a date field...

Assuming your date field is the current date, try this. Create a new formula field and type.... select DayOfWeek (CurrentDate) case 6 : CurrentDate+3 default: CurrentDate+1 DayofWeek will return 1-7 depending on which day number the date equates to. Currentdate + x will bring back whichever...

Try this. Create a new formula field. if right({yourfieldname},1) in ["1","2"] then left({yourfieldname},length({yourfieldname})-1) else {yourfieldname} ...which effectively says, if your field ends with a 1 or 2, then strip the last character off (regardless of character length), otherwise...

If you want to suppress based on a number of fields, I think you may be better working from the grouping options and hide detail altogether. (I always shrink the group footer if I want it to look like continuous records.) Drag all fields you need into the group header and you should have the...

You are suppressing the field rather than the section. Go to report/section expert. Select details on the left. Tick the suppress (no drill down) and click the x-2 button. Now you can type either isnull(yourfieldhere) or if isnull(yourfieldhere) then true else false that should do the job

Sometimes a line between sections isn't visible as it is so close to the section divider that you can't see it. to select it, left click in section 2 and drag your mouse pointer into section 1 (being carefull not to select any other objects). If a line exists, it should now be selected. Now it's...

Are they 2 seperate fields? ie, firstname and lastname? if so.... firstname & " " & Lastname (replace the firstname and lastname with your correct field name though).

UPDATE! OK, I have now tried the following. Using a different PCI card = This device cannot find enough free resources that it can use. If you want to use this device, you will need to disable one of the other devices on this system. (Code 12) restore registry from prior date backup = Same...

Thanks for the response. I forgot to mention that I did take the laptop apart completely trying to find something loose or damaged. The PCMCIA slot is fixed to the motherboard, and looked fully intact. I had checked the Resources tab in device manager, but unfortunately it says the device is...

Hi, I;m not holding my breath with this one as it seems fairly complicated. OS: Win XP SP2 Laptop: Dell Latitude C400 Problem Device: Wireless LAN PCI Card (realtek 8180) This laptop is fairly old, which I happily use for web browsing and not much else. Due to it's age, I use the Wireless...

If you are viewing records through a form, then you could replace the code behind the command button to something like... Dim vbresponse As Integer vbresponse = MsgBox("Are you sure you want to delete this record?", vbYesNo, "DELETE RECORD CONFIRMATION") If vbresponse = 6 Then DoCmd.RunMacro...

do users log out of your database overnight? I have a batch script that runs in the night that checks for a .ldb, providing one does not exist, it then compacts the database every single night. It also makes a copy of the db and saves it elsewhere as a backup, then writes a 1kb txt file...

I think your problem lies with the +. Change it to & and see what happens? I imagine that numbers will actually be a number! Out of interest, what was displaying in your message box?