Search results

Hi Gina, From what I saw briefly was that upon selection of a table name in a list box, the Subform's recordsource is set, The sub form contains 255 unbound text boxes. Access apparently assigns the columns to the control sources of the text boxes. The sub form is then requeried and properly...

I've got a coworker that is developing an app. He's trying to dynamically assign a subform's RecordSource. He swears that (through Google) the only events available are the OnEnter and OnExit events. That's true for the subform control itself, but the FORM itself does support them. I briefly...

J, Duh ... I quickly scanned it and missed the very first part ! I was just focused on the note. Wayne

Draw, That’s a good link ... but they say “usually” the same named columns. To not confuse kobiashi: each of the Union queries must agree in data type and number. Wayne

Joanchka, You should really break your column into length, width and units. Failing that you can use the Replace function to get rid of the unit part. Wayne

Kobiashi, Your append query should be a union query; even if some of the components have no rows. Wayne

Kronix, If your application data resides in SQL Server it will be contained in SQL Server's data files (.mdf, .ndf, .ldf). Their front-end software is accessing the database using some ODBC driver. Whether they use Windows Authentication or SQL Server Authentication you can emulate that...

aman, Here's a couple of links: https://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-practice/ https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode?view=sql-server-2017 Windows groups are easier for you...

Derek, Look at the system view: sys.dm_exec_sessions It'll give you user/database/hardware/performance data for the current connection. Note that if you connect/disconnect often; the stats are ONLY for current session. hth, Wayne

H, Will This Work? If it does, you can use this for weekly/monthly totals. Substitute your table/column names. tblUsage ======== UsageDate Datetime Electricity Integer Gas Integer Water Integer Select a.UsageDate, (a.Electricity - b.Electricity) As Electricity_Usage, (a.Gas -...

lemondrop9344, If you're still around look up the documentation for the Case statement. hth, Wayne

Not, I see that your initial post had a DLookuo on dbo_jobview. If this view joins multiple tables there's a chance that it might not be updatable at all. Especially if it has any domain functions (min, max, ...) More importantly if that view is comprised of the joins OF OTHER views, then...

Upon further review ... Does your table have an identity column? If access sees them, it will want to provide a value (can't do it). So it Can't be in the "add" linked table. But it must be in the view fir the "update" linked table. This gets messy real fast. If so, you're probably gonna...

Notanexpert, As for post #9, it looks like you have some blocking going on. When it happens, Exec sp_who2 and look at the "blk" column. It will show you which processes are in contention ... then all you have To do is figure out what they're doing :) Hth, Wayne

Leo, About the only way to accomplish this with a query is as follows: In addition to the PRIMARY id of [bner] you'll need another field that is unique within the set of [bner]s. An example would be purchase order number [PO_Number]. Select bner, fnTheNumber([bner], [PO_Number] from...

Tupamoche, It's been a while, but ... It never finished the Delete Statement (trailing parenthesis). [code] SET @SQL = 'Delete ' + @TableName + ' Where MRN IN (Select SourcePatientMRN from MRN_Processing Where Processing_code = 2 and Tbl_ID = ''' + @TableID + ''') Update ' + @TableName +...

Ridders, I think you can create a unique index and Access will let you update the view. Wayne

Untitled, You probably have the option checked to "Compact On Close". It should be in Options --> Current Database Wayne

J, You might try creating a View in SQL Server. Link it as if it were a table and even assign it a PK if desired. Hth, Wayne

Hi Ken, I just googled and you should turn off Tablet Mode. HTH, Wayne