Search results

Hi, I'm not sure where to ask this question... so I'll try here first. I need to change the value of one field for 50 specific records in one table. The change is the same for each record... change status to "Expired". I was going to just manually do it through the main form but I would like...

Hi, I need to change a field data type in one of my tables from Short Text to Long Text. The data currently conforms to the Short Text character limit but I redefined the use of the field so it will soon require more room. Can I simply change the data type or is there something else required? Gale

Hi, I was asked to help someone create a view in an Access Database. The person who was responsible for the database has left the company and so the department is scrambling to make some small changes. They heard I have recently been learning about Access so they asked me for help. Rather than...

Is there a way to skip buttons on a form when using the Tab key? It would make tabbing from field to field a little smoother... in my opinion. Gale

I am using a single form to add, edit and view records. When I add a new record I would like to populate the "CreatedOn" form field with the current date. I think I can use a Form event for this but I can't figure out which one. Or is there a better way of doing this? Gale

Hi, How do I replace the contents of a table? I was planning to delete the existing records and then import new data but I am not sure that is the proper way to do it. The table doesn't have any relationships to other tables if that matters. Gale

Hi, I recently lost some VBA changes and haven't figured out what happened. Recovery was simple so it's not a big problem but it caused me to question what I think I know about saving in Access. When I save from the VB editor it saves the entire database (its not split) so any form changes I...

Hi, I need to enter the current Date/Time in a form field Txt_BARTinvoiceSub This form is used to update existing records. The recipient Table Field to be updated after I get the correct value in the form is formatted as Date/Time. The following results in pound signs ######## entered into...

I have a VBA import routine that extracts data from specific cells in an excel Worksheet. This routine must only be run on a New document. I also have a macro button to create new documents. How can I determine if a new document has been selected on the form? Gale

I have written the following to extract data from specific cells in an Excel Workbook into an Access form. It works until I try to write the extracted values to the form fields. I get a Compile Error "Methos or Data Member Not Found" on "Me.FormFieldName.Value = CellVal". How can I correct this...

Hi, I am trying to find a VBA example that copies Excel data from specific cells in a Worksheet to an Access Form. All I am finding is examples of Access import. Can anyone direct me to a reference or provide an example? Gale

Hi, I want a button caption to be AT&T... I know "&" is a special symbol but is there a way around it? Right now all I can get is ATT... which I can live with if I have to. Gale

Hi, I want to create a new table in an existing Access database. But when I look under External Data and mouse over the selections they all say "Export". How do I get to "Import"? Gale

I am new to Access and in the process of creating a database to replace one written in Lotus Notes. I have a single table that contains all of the data from the other database. I also have a functioning form to Edit and Add records. Now I want to move the Building Address out of the first table...

Hi, I am a working grandfather hoping to retire some day ;) I am not familiar with Access but I have over 30 years experience developing databases in Lotus Notes and creating engineering tools in Excel. I also have some experience with Oracle databases and SQL. But I'm far from an expert in...