Search results

Using Excel 365, Win11 Machine [ Sub OpenReferenceDb(control As IRibbonControl) ' create new access object ' declared in general declarations Set appAccess = New Access.Application ' open the access project Call...

I am importing a flat file (*txt pipe delimited) into sql server. As you may see for column five (call_sign) nulls are not allowed. Yet I get this error when attempting to insert: Any help would be appreciated. TIA doco

I am using Office 365 on Windows 10 Pro machine. I have two tables referenced having a 1:N relationship. The one side table has several fields that get populated using Lookup Wizard through a dropdown box as does the many side. The problem is one of the fields from the one side table insists on...

Apparently, there is no way to create an add-in database (.mda, .accda) in Access 365?

Is there a way to change the default for forms from tabbed to overlapping? Tabbed is just stupid... TIA doco

A simple text box being populated by a command button instancing the DoCmd in the subject line. I have used this extensively over the years and it works fine until now. Private Sub cmdImage_Click() Me.image_path.SetFocus Call InsertPhotoLink End Sub Public Sub InsertPhotoLink()...

Using MS Access 2013 Me.txtGrzAccts.Value = vGrz Me.txtTbrAccts.Value = vTbr These two statements are embedded in a bit of vb in the Report_Load event. The attempt to add values to those fields (located in the Report Footer) create the subject error. Oddly, if opening the report...

With rs .Edit .Fields("full_name").Value = szFullName .Fields("issue_date").Value = szIssueDate .Fields("eff_from_date").Value = szFromDate .Fields("eff_to_date").Value = szToDate .Fields("status").Value = szStatus .Fields("type").Value = szType...

Using Access 2007. Is there a flag somewhere that will keep Access from using [Embedded Macros] in place of VBA when using control wizards? (Macros UGH!) Thanks

I would like to take advantage of using combo boxes to search records on a form but do not want user to be able to edit or change any of the data. Setting the form to read only of course, disallows use of any controls on the form. How is this done? TIA

Been trying to use wildcards in fields while Filter By Form instanced in Access 2007. LIKE, BETWEEN, IN or */% not available? The form is based on a query. I am guessing this is why the drop downs only show IS NULL or IS NOT NULL as choices instead of the entire unique list existing in the...

Access 2007 Pro Attempting to use a query and a table to populate a 1:N form/subform using the Form Wizard. The wizard will not display the field names of the query. Ideas? TIA

I am using a timer to flash text vbRed|vbWhite|vbRed. The process works fine except the form gets the palsy while the text is adjusting to the timer events. Is there a way to stop this? In Excel there is an Application.ScreenUpdating = False method. Is there an equivalent in Access? TIA

I am currently using Office 2007 Pro on an XP Pro system. Access is 2007; Excel is 2007, et al. I created a database over ten years ago and have been using it since; which would include upgrading 2000 ---> 2003 ---> 2007. No problems. About two years ago now I exported all of the Access tables...

I have a report (in a small report database) that is based upon a query as most are I suppose. I have done some maintenance on the naming conventions, queries and forms. The database was created five years ago. There was a field name [Instrument_#] that as you may know is potentially a problem...

I am attempting to open an additional form using a command button on a main form to add additional data relating to the data on the main form. What I want is for the opening form to display the related field in a field on the opened form without user having to enter the data and ready to enter...

That I am aware of the only thing in life that is certain is death. However, I can guarantee with equal certainty I will never have a need for [Tabbed Documents] option - not sure why anyone else would either. Anyway, [Tabbed Documents] oddly enough is the default for new databases. Is there a...

UPDATE district_rates SET district = 'CITY OF FOSSIL BOND' WHERE district = 'CITY OF FOSSIL - BOND' I get 'Must use and updateable query' error when running the script above. Sorry, the script above is about as updateable as you can get. So, any ideas about what is really going on...

Is there a limit to the number of tables and Access 2007 db may link to? TIA

I have Access 2007 running on an XP Pro machine. I have a SQL Server 2008 running on a MS Server 2008 R2 Box. However the databases are SQL 2005. When using the SQL Server Upsizing Wizard I get the following error message: HUH? I have property permissions, DSN and the server indeed exists. TIA