Search results

Currently, in Access 2003, we use a common ChangeProperty module to lock down our databases. Does anyone know how I can set the application's ribbon in 2007 by using this type of module?

Thanks, Bob, that is helpful info. I've only been playing with 2007 for about a week now. It's like a new toy. But in my world, we have 3 environments. One for development that has a Modal form that has a text box. The correct word entered in the text box will close the form and expose the...

I recently was asked to find out what it would take to migrate our applications from Access 2002-2003 to Access 2007. We use a fairly sophisticated custom built secuity wrapper. I think once we get used to ribbon customization, it will be quite useful. But one thing I am concerned about is...

Sorry I haven't gotten back 'til now. My manager agreed with your regional settings solution. But my settings were set correctly. I did solve the problem, though. On the report (which is not displayed anyway) I place an apostrophe in front of the date. This makes ACCESS think it is a text...

I am using the OutputTo method to output a report to Excel. But the dates on the spreadsheet display as Julian, rather than Gregorian. Can I use a template to control the date format?

We have always used the Calendar control provided by Microsoft. Since we have gone to XP it no longer works. There is a missing reference. I have found the MonthView control works fine. I would like to hear some opinions on MSCAL vs MonthView.

Thanks! That's exactly what I was looking for.

Lately I've been doing a lot of importing and exporting of data to text files using stored specs. To see what fields and sizes a spec contatins I have been going to the File menu of Tables, click on Get External Data/Import. When the Open menu comes up, I click on any random text file. Then...

Does this mean even though the header appears at the top of the table when it is opened, it may be stored differently in the database itself? By the way, I appreciate the suggestion of using a query.

Does anyone know what would cause records in a table to change their sequence? I have a table that I clear out. Then I append a header record. Then I append the detail records. The table always is populated correctly. But sometimes, when exported to a text file, the header ends up down...

Thanks for the help!!

Does anyone know of an expression I could use in a query to parse a full name field into last name, first name and middle initial?

For anyone interested - My problem had to do with the overhead in the append query. My table indexes were not set up correctly and I was doing a Group By on every field in the query to eliminate duplicates. A normal file of about 3,000 records would run in a couple minutes, but 80,000 could...

Hi- Im importing 80,000 records into a table and then using a query to reformat the records and append them to a second table. The import works, but the append quits after about 6500 records. Is there a limit to the number of records an ACCESS query can handle?

We have SPEED Ferret 4.1, but we've upgraded ACCESS 2003 which 4.1 does not support. Does anyone know if a new version's coming out? Does 2003 have its own enhanced find and replace functionality?

I hope this is a simple question. I have linked my front-end to a rather lengthy textfile (over 700 characters) using the wizard. I would like to change some field defintions. Can I do this in ACCESS 2000 without redefining the whole record?

I have a form with a rather long subform. The subform has various data entry controls. Tabbing through the subform works fine unless focus leaves a checkbox and is set to another. When that happens, the subform is repositioned to the top (kind of like it's been requeried). The user then has...

I have some rather long subforms that I load onto a form with a click of a button (OnClick: Me!SubfrmSurvey.SourceObject=.....). As the user tabs through the form, the cursor continues down without repositioning the subform. Is there any way to keep the cursor visible without manually scrolling?

This still didn't work because SrveyForm does not exist in the Forms collection. I really don't want to create another form. It is not the direction I intended to go. Basically I wanted to know if there is a way to use a variable in a Forms statement ie Forms!<Variable>!MEMO1. But due to...

Actually, I do populate the field before rumming this code.