Search results

I have a query which returns a calculated percent. I have ordered that in descending order, and now want to see the top 50. So (In Access 2010) I entered 50 into 'Return'. But it returns all of the records! Is this because pct is a calculated field? How can I correct this? The SQL seems to be...

I am trying to deduct a datetime field from a date field to decide how many days are in between. It doesn't let me. So do I need to convert the datetime field to a date field first? How would I do that? Or is there a function I can use to calculate the date difference? Robert

Yes, this is a DateTime field. I have not seen this before using BETWEEN with date fields. Do datetime fields work differently in BETWEEN? Robert

I am using Between Me.Firstdate and Me.Lastdate in a query. I thought that it would include both Firstdate and Lastdate in the range. But it appears that it does not. Is there a way to include Firstdate and Lastdate in the range of dates? Robert

That's odd. I tried this myself and got a copy in my 'Sent' folder. But the user concerned never gets an email in her 'Sent' folder from this program. Robert

Thanks, that worked well.

I am sending an email using SendObject, like this: DoCmd.SendObject acSendNoObject, , , eMailAddress, ccAddress, , Me.Subject, Me.MessageBody, 0 The email is sent correctly. However, in Access 2003 a copy was posted to the Outlook 'Sent' folder. Since we have moved to Outlook 2010, a copy...

I am not typing into the memo field. I am taking fields from a record and adding them to the memo field, which is then displayed on a form. So my question is, how do I force a new line? It's been a while since I worked with CHR() values. Would CHR(13) force a line feed?

When I am displaying a memo field, is there any way that I can force a new line? Can I add a character to the text to do that? Robert

I have a quite simple query which dispays records EITHER if the priority level matches the control on a form, and the level is "CLOSED' OR the priority level on the form is "All' and the level is "CLOSED'. I get a formula too complex error. What can I do to eliminate this error? Robert...

I am in Access 2010 and on a continuous form I am getting alternating light and dark bands on the background of the form. How do I turn that off? Robert

I am new to Access 2010. When working with a form, how do I display the field list? The list of fields for the table associated with that form. Robert

Thanks so much. I see it now! The images were most helpful. Robert

I have tried that. I get 'More Commands' and not 'All Commands'. Switchboard manager is not one of the options. How can I get that? If I can't get Switchboard Manager I have to redo all of the menus in my app. Robert

Thanks so much. I will give that a try. Robert

I have an application developed in Access 2003 which uses many switchboards, developed with the switchboard manager. Now I am using 2010 and can't find the Switchboard Manager. Is it still there? Robert

How many MB the table uses, within the database. Robert

Is there a way to display the size of the tables? I am using Access 2010. Robert

I have an application with about 30 remote users. The back end data size is about 500mb after Compact & Repair. However, we are often seeing it grow to over 2GB in a day! We can compact and repair at the end of the day, but we see corruption before then. Possibly caused by the database...

I have just updated a big mdb database to accdb. But we have two associated databases that cannot be updated - they are for UPS and Fedex data, which presently does not support accdb. Can I link to mdb tables in another database from my main accdb database? Robert