Search results

If it's a corrupted record try the methods described here.

You are opening a form, asking for a password won't prevent this if there's no action to prevent it. On a wrong pasword close the form like: Private Sub Form_Load() Dim PassWord As String PassWord = InputBox("Enter You Know What Virginia") If PassWord "xxx" Then ' Open...

NO. Al you want can be done in a single query, why create 10 querys. Depending on your needs the grouping (the ∑ in the lint) can be on startdate and location and a total for the Fuel used. You can base the filter critera on a form for easier use. Something like: SELECT Location, StartDate...

I think you need a Union query. Do all query's have the same number of fields and colum order? If so you can copy the query SQL and append a Union (or Union all) after each query like:SELECT * FROM table1 UNION SELECT * FROM table2 ... SELECT * FROM table10; A Union query cannot be build in...

You can use the HasData property of the report, as this returns True or False you can set the visability like: Me.Label12.Visible = [YourSubRapporControlName].[Report].[HasData]

Sounds to me you're using a secured mdb file. Are you using the correct mdw file? More info can be found here.

As you are concecating strings use "&" in stead of "+", your trying to add something different what can give unwanted results. Because you are converting to string the "+" works in your last post, trim isn't needed. const IndexCol="A" dim IndexRow as long dim RangeAddress as string for...

In a new colum in the field row copy: SubFolder:Split(Folder, "/")(4)

split(folder, "/")(4)

You can create a query and reference your table twice link them and place the right filter. Something like: SELECT YourTableName.Account, YourTableName.Process, YourTableName.TasK, YourTableName_NonSweep.Account, YourTableName_NonSweep.Process, YourTableName_NonSweep.TasK FROM YourTableName...

Is this in a runtime or with access 2010 and what version of Windows. You don't get the warning straight from access (so setting warning on/off won't help), it is a windows protection mode to prevent unsigned code to run. Placing your frontend in a trusted location should work. For more info...

Sorry, missed the part where you use "set db". You need to close the db by: db.close set db nothing 'also cleanup your workspace by: ws.close set ws.nothing

Don't know if it works but try a "DoEvents" before sending the mail.

Define a function is loaded like: Function IsLoaded(MyFormName As String) As Boolean IsLoaded = SysCmd(acSysCmdGetObjectState, acForm, MyFormName) End Function And test like: If not(isloaded("frm_go_live") Then MsgBox "Please ensure the go live form is open before attempting to run...

Comment the line "On Error GoTo Err_Search_Click" out so you disable the error handler, run your code and if it fails the debugger will highlight the line with the cause (most of the times).

You let the SQL process the now() function, I find most of the times running SQL from VBA with VBA native functions won't work. Replacing the DoCmd.RunSQL with currentDB.Execute will remove the need for setting the warnings False/True

Do a compact and repair, they look like deleted forms. Access keeps the deleted stuf until you do a compact an repair.

You did not mention the result of my solution. Again your combo is bound to column(0) (that's the first colum = 1), columwidth is probably set like 0,2inch (or 0;2cm depending regional settings) where the first colum is hidden and the second (column(1)) is visible. Check the datatype of the...

A combobox is bound to colum(0) so you need to use the projectID and not the projectName.Me.cboProjectName = [projectID]

You need to link your order table twice and put in the critera you need, someting like:SELECT tblCustomer.Name, tblCustomer.Adres, tblOrder.Item, tblOrder_1.Item FROM (tblCustomer INNER JOIN tblOrder ON tblCustomer.CustomerId = tblOrder.CustomerId) INNER JOIN tblOrder AS tblOrder_1 ON...