Search results

For info MS issued an update to office around 19th July 2022 that fixes the bug in the version released on 12th July 2022. We found however just updating office alone did not prevent this error occurring, it was also necessary to uninstall Access Runtime and re-install it.

I have a form with a project selection button. A user selects a project then clicks a button. When this happens a pass through SQL query is produced. The code is here: Private Sub cmdIssueList_Click() On Error GoTo err_cmdIssueList_Click Dim strSql As String Dim strQdfName As String...

I have been developing databases for my company for some time now. All have a default "splashscreen" form that opens up when the database is opened by a user. In the background VBA runs on the "on open" event of the form to validate who the user is via their windows username. All my databases...

Haha just found the answer myself, when I save the link using vba I need to enclose it in "#" each end. I was worried about doing that in case they showed, but it appears not, what they do do though is make the link work.

Getting pretty confused. I have a backend database in MS SQL with a field called Link set to Varchar(Max). I have a front end Access database containing a bound form with a bound subform. The subform contains a field called Link with source bound to the "Link" field in the SQL table. It is...

I can confirm that putting a dummy record in overcomes the date issue and allows import to proceed :) will need to create an excel function to do this for all six tables.

Will give that a try too, but the process is starting to get more manual than I would like. Export from web database as csv (the only format it allows), open in Excel, re-export as text file with different delimeter then import. In total there are 6 different CSV files I export from the web. The...

I will give that a try

Not sure it will work for the very reason you state "..It gets really complex..", Ironically the file actually starts life as a CSV file and contains thousands of lines, but there is a notes field that will contain many instances of commas. For that reason I ruled out any form CSV import...

I did wonder that and will give a try, one problem I may have though is only 4 of the 5 date fields are ever used at once and the 5th is rarely used. So chances of getting 5th anywhere near top is slim.

I am trying to import data from an excel worksheet (WS) into SQL but I am having a number of issues. The import export wizard is incorrectly identifying data types. There are two columns on the WS that contain only a heading, nulls and integer values but the wizard classes then as double...

I use DSN Less. I have error handling in all my forms including a splashpage that opens when the database opened (to check username, initialise all variables etc.). I will need to go and experiment I think the Ms Dialog box beats my dialog box. When it pops up it prompts the user to enter...

I currently run a number of Access databases as a front end that connect to databases on the company SQL server. The connection method I use is windows authentication. All front end databases I distribute are compiled accde files. The IT department who are responsible for the servers have...

How do I use rich text formatting? I tried inserting the HTML code you suggest in the text string I am inserting but all that happens is the HTML tags appear in the word document.

I run all queries that pull or push data on the SQL server itself. Some of my databases don't have any tables, not even linked.

There are two main reasons: Over the years I have had a number of occasions when inexperienced uses would modify/delete data and then close the form not realising they had done so. So I started to use unbound forms to have more control over users. Generally the forms I display have view...

I'm with you, the two volumes I learned Access VBA on, I have not come across any books since written as well and informative. Many Access book don't cover much more than the software help does.

For some time I have been designing all my database with unbound forms that input and output data on a SQL server using VBA. To protect against SQL injection on all my forms for adding and editing records I use a simple function I created: Public Function MakeSqlSafe(varInput As Variant) As...

I am using Access to insert a string into a table cell in a Word using VBA. The string is of the format: "Subject 1: text goes here & vbCrLf & Subject 2: More text goes here & vbCrLf & Subject 3: Yet more text goes here" In the word document I would like it to appear like this: Subject 1...

Thanks for that I will take a look. I must confess I didn't consider reports. I used reports when I first started using Access in 1998 and could never come up with an appearance I was happy with. I haven't created one now for over 10 years and for the last 10 years I have used Access to generate...