Search results

My main concern here is Mission Critical Data. The data on the W98 machines. What back procedures are currently in place and how often are they being done? Are they incremental? The first thing I would do is to stick in a slave drive and port all the data onto the slave drive for safety's sake...

If you are using Access 2007 you may need to ungroup the controls first.

varRP = Me.RPphone strSQL1 = "SELECT [RPcontactnumber], [RPid]" & _ " FROM ReportingParties" & _ " WHERE [RPcontactnumber] ='" & varRP & "' ;" Set db = CurrentDb() Set LRS = db.OpenRecordset(strSQL1) If LRS.EOF = False Then Me.RPid = DLookup("[RPid]", "ReportingParties", "RPcontactnumber = '"...

What does your actual code look like and where have you put it?

Have you tried this Link

Do a search on Blob To File When you look at the table in datasheet mode what does the ole field say? Bitmap Image? Long Binary Data? Something Else?

Firstly you need to decide which information has priority over the other in terms of accuary then you need to build a DFD and and ERD to merge both processess. Then perfrom some gap analysis on both sets of data. The data is the key component here, get that right and the rest will follow. How...

Create another set of fields that are formatted yyyymm and filter on them

You cannot add items to a listbox that rowsource type is not Value List. You would have to append the item to the table then requery the rowsource.

=ColumnHistory([Tabel1],"Commentaar","[ID]=1" & Nz([contact_ID],0)) Remove

I don't think our paths have crossed over time, however, may each day bring you one step nearer to perfect health and happiness.

Dates formatted as April - 2011 etc are treated as text strings not dates. That is why your filters are not working.

There are no design changes taking place, the only thing that changes is the connection string in the MSysObjects table as per linked table manager. The original vendor had unsplit databases one for each client. Any changes he made had to be replicated over all his apps. Finally getting him...

.DeferredDeliveryTime = DateAdd("d",4, Me.FUDateContacted )

Hi BOB Just to clarify, If I have a Accdb that has linked tables, these linked tables can be changed from one mdb backend to another. It is a multi company application that stores individual company details in their own mdb's. Not my idea it is a legacy system. The setup screen allows the user...

You can use the DateAdd() function to add 4 days to the initial date FUDate = DateAdd("d",4,FirstDate)

Use a query dT:[Time]*[Value] But don't have names like Time and Value as they are Access Reseved words.

This is a duplicate of an earlier thread. Why reposting?

Don't think you can with Err.Descripton as you have know idea what the description is. However if you raise the error to determine the message you could manipulate it to suit your needs.

You cluld improve the efficiency by changing This STLT = DLookup("[sumOfTemperatureTimesLogOfTime]", "queTeArrheniusPlot2", "[Report_number] = " & Report_number) SLT = DLookup("[sumOfLogOfTime]", "queTeArrheniusPlot2", "[Report_number] = " & Report_number) ST =...