Search results

Is this issue related to ANSI 92 compatibility? and will changing this resolve the issue? It did seem to in the sample accdb I created and George sent to you when I updated to 2311. Note to others: you won't find this setting in Options for Current Database, it's in the Object Designers tab

OK, I've got the same issue with a combo box. based on a table with 2 columns and only 2 rows. 365 Enterprise 32 bit, accdb in Windows 11 I've even copied a known good combo box from another application and changed the rowsource. Problem persists Tried changing the setting for this application...

The simple answer is Public Sub ReplaceInSQL() Dim qdf As DAO.QueryDef Dim strFind As String Dim strWith As String strFind = "Whatever" strTo = "Whichever" Set qdf = CurrentDb.QueryDefs("QueryName") With qdf .SQL = Replace(.SQL, strFind, strTo) End With End Sub...

The simple solution is to share responsibility for testing with your client or the project manager. With the client having responsibilty for the final testing. I don't release a new version, they do. They must have a critical process test plan that they go through to ensure that there will not...

@Jackoo6 - this is the link to Geroge's post with a link to the video Migrating tables to SQL Comparison

Are you in a multi user environment? ie are you sharing your database with other users? If not then LarryE's suggestion will suffice. The only problem with this solution is, if you have multiple users working on the same table. Users' selections can be affected by each other's selections. A...

Must agree that a Deleted Date and Deleted By column is the ideal. Then filter your record sets to Where Deleted Date Is Null. When users complain that data has gone missing and, as the developer, it's your fault, you can show them why and even recover it.

My ultimate objective in listing objects was to be able to list object dependencies without using Track Name Autocorrect (for obvious reasons). This is rather useful. To achieve this, the process • first updates the lists of objects. • Then searches only objects that have changed to list which...

The process I use is more about version history but it's kinda the same thing and I will run it sometimes when I just want a backup even though I'm not releasing. The process documents all the objects with Created and Modified dates, and Version Number then exports to text if they are new or...

Users should all be using their own copy of the Front End, so they should all currently have an ADP. You should be working on an accdb that you will give to everyone else once you've got it working and tested. So in the mean time other users should not be affected. The MAIN difference is that...

BTW "instatiatle" is just my word for instantiate. and kill the form pointer in the class Private Sub Class_Terminate() 'Clean up objects Set mfrm = Nothing End Sub or you may find your application slowing over time.

If you use a class, you can specify which events. Declare the class in your form's code and instatiatle it in the open event then call the class's Init method In this example I use the class to do the job of code behind a continuous form. Private WithEvents mfrm As Form 'Holds the form pointer...

For modules, you won't get the last modified date. Apparently 'LastUpdate' refers only to the module documents collect as a whole. I found that I needed to run a hash comparison (MD5 Hex as I recall) to see if any changes have occurred and then use the date of the comparison as the last modified...

Code to insert Code Public Sub EventProcedure_Insert() On Error GoTo Error_Handler Dim Frm As Form, mde As Module, obj As Object Dim strForm As String Dim strTarget As String, strCode As String, strEnd As String Dim lngStartLine As Long, lngStartColumn As Long, lngEndLine As Long, lngEndColumn...

When I create a table in SS from VBA, I create the table with just the PK strSQL = "CREATE TABLE dbo." & strTableName _ & " (" & strFieldName _ & " INT IDENTITY(1,1) NOT NULL" & vbNewLine _ & " CONSTRAINT " &...

KMan, I had a similar experience except that it was with combo boxes not text boxes. This was on a single record view, unbound form. I removed and recreated to fix the issue. But then I had crashes on another (Continuous form). again, combo boxes. After much addoo, wailing, nashing of teeth...

@Jike Krailo "There are many DB's that will never have the need to move to sql server." very true, I was attempting to provide Pros as well as Cons but will admit I'm a bit biases against attachments, or any other non conforming data type, because I spend much of my time migrating the...

arenpg is correct. If you can, keep the file external to the db and only store the file name (or full path) in the table. But you will need to save the file to a location that all users can access. storing the image as an attachment in the db bloats the db and the attachment data type is not...

Yep, I looked a Parallels and was quite impressed but I've no where enough users to make it worthwhile. Thanks AJ, might save me from ripping both my bluddyarmsoff.

Pat, why do you think this might not work in a multi user environment? is it because System_User may not be reliable? Or because of the possibility of the same user opening more than one instance of the application? or is there some other reason?