Search results

I'm not sure this will work but you can try using the FileCopy statement in VBA to make a copy of the target excel file and use the copy for your linked table. The only caveat is that you should make sure that the original excel file is saved before copying it so you always have the latest data...

One way is to enforce referential integrity in the relationships. Though that will filter out the non-DB guys, those with some understanding can still enter data to the parent table and child table. Anyway, the only reliable way I could think of is to change the way your front-end accesses the...

You got your nested IIF all wrong. CODE:Iif (IsNull([Forms]![FrmSearch]![StartDate]),<=Date() And <= [Forms]![FrmSearch]![EndDate], Iif(IsNull([Forms]![FrmSearch]![EndDate]), >=[Forms]![FrmSearch]![StartDate],Iif(IsNull([Forms]![FrmSearch]![StartDate]) And...

Yes. that's much simpler

create a function in Module Function FindReplace(FindString As String, Substitute As String, StringExpr As String) As String Dim n_Pos As Integer While InStr(StringExpr, FindString) n_Pos = InStr(StringExpr, FindString) StringExpr = Mid(StringExpr, 1...

Re: Inable or Disable Edit record if you don't want your records to be accidentally changed, create a button that moves record with this code docmd.RunCommand acCmdRecordsGoToNext if Me.AllowEdits = False then 'do nothing else Me.AllowEdits = False end if To allow editing...

Yes it is possible. I have worked on several projects like this. I use MapWindow. Check out www.mapwindow.org. They even have a sample using MS access as a database. With a bit of VBA knowledge, you can even use it on a powerpoint presentation while having it read live data from any database I...

Try this SELECT TOP 50 Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.ReorderLevel FROM Products ORDER BY Rnd([ProductID]); The idea is to display the records randomly by using the Rnd() on the integer primary key This is a much simpler solution. I hope...