Search results

If you only want to find the task name, and the number of people working on it doesn't matter, then you could use "split" on ";" to get an employee number then dlookup on that, or if you need to do it for each person, then do the same and loop through the array for each one.

Depends on how you want to show it really, but something like this? Consumption = Dlookup("[Consumption]","table","[Date] = '"& format(dateadd("d",1,EarlierDate,"yyyy-mm-dd") &"'") - Dlookup("[Consumption]","table","[Date] = '"& format(EarlierDate,"yyyy-mm-dd") &"'") That would give you...

Off the top of my head an array might be a way to go with it, built either from the excel sheet or the dB data.

There are better ways of doing this, as has been suggested using the logged in user and setting permissions, although if a manager was to use another persons machine they wouldn't be able to do that then. Having a single password means it's not very easy to change, and if someone tells someone...

In an OnOpen event for the form, add a bit of code that captures the date you want to look at from an input box, add some checks to make sure that a date has been entered, i would then check to see if there are any records with that from using a count, if there aren't give the user option to...

If the variable in the combo box is the same most of the time and you only change it occasionally, then you could just set the default value of the combo box to the most common selection and only change it when you need to, therefore speeding up your process. Having the list boxes working on...

Do you mean something along the lines, if you select one of the options in say "File" that will open a sub menu for different options up in there? if that's what you are looking to achieve, you would be much better to do it with a custom ribbon, this is what i have done on mine to do it with a...

I'll give that a try tomorrow and see if it makes any difference. Thanks

I would store this information in three tables, for example: tblBrand BrandID BrandName tblModel ModelID BrandID ModelName tblDescription DescriptionID ModelID DescriptionDetails That would link everything together, you could add additional fields to tblDescription for...

I have a DB with a MySQL back end. Lots of people use this and it works brilliantly. Recently IT decided to change the server the back end is hosted on to another domain, so all the ODBC connectors on machines were updated to reflect this, it changed from a named server to an IP address...

SELECT TOP 1 has done the job i think. Thanks

No, when ran in SqlYOG I get the exact result I am after, all I want is the 1 record. But when run in Access with the "LIMIT 1" in there, the qry doesn't run, remove the LIMIT 1 and it runs absolutely fine.

Hi, I am having problems getting the below query to work in VBA. If I remove the "LIMIT 1" from the end it works, but how can i get it to work with the LIMIT 1 in place? Set rsCheck = db.OpenRecordset("SELECT * FROM processed_obox_Headers WHERE OboxID = " & OboxID & " AND TransmitTime BETWEEN...

Thanks for the solutions guys, it's appreciated. Brain is now well and truly frazzled, this working on a Saturday is no good. It was only meant to be a simple ting to do, but has turned into something more of a pain, so for now it works, and i'm going to leave it at that, and put it on the...

Hi Guys, Hopefully someone can help with this, sure it's easy to resolve, just can't quote join the pieces up together. I have a report which will generate a pick list for the warehouse, can print a single version of it for a specific order absolutely fine. I have added a button to allow the...

Have found a work around of sorts. When the DB updates, it now sets a field in the user table "RibbonUpdated" to 0, when DB opens if "Ribbonupdated" = 0 then it sets the ribbon name for the right ribbon in the USysRibbons table, prompts the user DB will close and to re-open straight away. Not...

I have a custom ribbon which loads and work perfectly. I now need to create some different views for different users with the app, each different type will need a different ribbon. I don't want to run 3 different version of the app, so want to load the specific ribbon when Access opens. I...

Ok. I've put everything into a normal query, and it shows all the data, left the date format alone as normal, and sorted ASC on the date. Created a Crosstab based on that, applied formatting to the date field in the cross tab and it didn't make any difference.

Tried that, and it appears to ignore the sort from the initial query entirely. Have just re-tried it without the format mmm-yy on it, tried ASC and DESC and it makes no difference, it appears to pull the sort from the cross tab query only.

Thanks for the help guys. I have decided to go a different route. At a certain point before the form opens, all the records will be created with a 0 value, and displayed in a cross tab. There will be a drop down for the element and month, and a text box to enter the amount. The user can...