Search results

you can use InStr, but you need to use it in conjuction with a loop as pr2 suggests above. Is the number part always the same number of numbers or can that vary, from your example below, the number part seems fixed at 27 characters, so you could try Function extractNumberPart(incomingStr As...

go to your backend database in SQLserver and try adding a new field to the table, make it a timestamp datatype. Do not try to use this field in your Access front end, but should prevent the write conflict you are experiencing. David

I think you can just test the value of KeyAscii and use it to trigger an event i.e. If KeyAscii = 65 or KeyAscii = 97 'which is 'A' or 'a' key MakeFunctionCall End If

You've haven't included what is the most vital piece of code, how you set/create the email body David

have you tried inputting exactly the same date into both fields? Also is this a standard Access database or does it have a SQL server back-end? David

Have you tried stepping through the code to see where it's failing. Check the values in Me.lstData.ListCount There is one line which possibly looks suspect, the line Set oXL = CreateObject("Excel.Application") You may want to try testing to see if Excel is running, if it is then use...

I would suggest using 2 text boxes, txt1 one would store the number of minutes (Integer data type) and the other txt2 would be a standard text field. When the number of minutes is updated in txt1, you can update the value in txt2 using something like Me.txt2 = Format(Int(Me.txt1/60), "00") & ":"...

I'd suggest doing this in steps. If there are issues with the data types not matching, import the Excel file with 5 columns into a temp table first which has a text data type for each field, then move this data into another staging table that has the correct data types, transforming the data as...

this is doable because it works in my organisation. Access 2003 database is split and the front-end is saved as a .MDE file. A script has been written so when users click on their application icon, it pulls down a run-time version of Access and the front-end starts up. I've written a startup...

try using the after update event of the depot text box to trigger what you're trying to do. After the text box has been updated, do a Dlookup to see if the depot exists, if it does, set your criteria and filter the subform, if the depot doesn't exist, do nothing

I think you may need to rethink your approach. You're defeating the object of a live database, you want users to be able to update data while also expecting to have the table(s) in design mode, no can do! You need to plan some database downtime if you want to make changes during normal working...

something appears to be seriously wrong in your logical approach, as BlueishDan stated, you can have a form bound to a query, but the query can't change depending on criteria from it's own data source. If you have combo boxes on the form, they should be bound to a table or query, but if the...

what you've attached does not have any colour coding, are you intending to use the colour code column as a key to what the colouring should be? I can see a way of using the values in that column to set the clouring in that cell David

if i understand you correctly, what you are trying to do is illogical, when you say "Forms!frmeventbuild!Form.frmBUILDsub.EMPLOYEE.Value = " this line above is the full object address of the field EMPLOYEE on your subform. It does not specify a record and the database is not into guessing. I...

Instead of: Reports!stReport_Name.Recordsource try Reports!" & stReport_Name & ".Recordsource David

have you tried a simpler approach by simply creating 2 queries equivalent to your 2 recordsets (name them Blatt1, Blatt2), then export them to the same workbook using the TransferSpreadsheet method, this will create a workbook with 2 worksheets named Blatt1, Blatt2, then you can go about trying...

as a start can you post a sample of what you'd like the excel output to look like David

You may have to reconsider the logic in what your trying to do. If each item can have multiple destination paths, then you need to query the source data to retrieve all the destination paths for that item. Use that query SQL as the recordset source and iterate through those records, setting the...

have you tried copying the BE file to the same machine where the FE file exists and then try relinking. The error code doesn't look to be a standard Access error message, have you written in some error trapping code that will spit this out, if so try debugging it and see where it errors David

I think you just need to think through clearly what functionality you want to allow when one or more events are dependent on another/other event(s) or controls. I've usually found it's best to restrict the pathway of events a user can take by hiding/disabling controls until valid...