Search results

What are you actually trying to do with this expression? "*criteria1*" - this will search for records that have the text criteria1 anywhere in it's value.

Instead of objBook.Close Try : objBook.ActiveWorkbook = Nothing objBook.Quit Set objBook = Nothing

Try using NOT infront. If that doesn't work you could easily say <= [start date] Or >= [End date]

What a messed up country! What's wrong with being polite, I always step back and let others go infront of me.

I would of helped but it's against the rules so you'll have to go elsewhere. I had to "crack" my own database I made years ago because I forgot the password, pretty stupid I know but it happens! Not hard to search google anyway.

Click just above the field name so it selects the whole column and then press delete. Edit: Paul always beats me. :(

Use an append query not an update query. In the criteria of the column you want to start with v insert : Like 'v*' This will select all records where the column data starts with v and anything else after the v.

Looked it up online and it seems navigation forms are something new added to 2010 so I probably won't be able to help, sorry.

Some more details would help and possibly a screenshot. If you convert you database to access 2007 and upload it, it would help to get a better understanding of what your doing.

David Tennant has been by far the best! Him with Rose Tyler (Billie Piper) were unbeatable! Haven't watched it proper ever since.

The site has been great for me all day, you sure the problem wasn't at your end?

That's quite worrying they were able to do that and it took this long to find out. Hopefully it won't happen again because the site performance is great right now, was frustrating for two weeks with everything being so slow to load.

Any add on software will most likely have to be bought, no point when it's simple enough to do! What have you done so far? Have you retrieved the date from the calendar control and used that in a query? In the query criteria under your date field you would put something like: Between...

Well it depends on how you enter your data into the table. Or have you already got the data in the table? Unless you need this numbering system for some other reason you could easily use an autonumber in your test table and also include the primary key from the project table in the test table.

Assuming the excel files have the same format here is a snippet I always use: Dim strFile As String DoCmd.SetWarnings False ' Set file directory for files to be imported strPath = "C:\....\....\.....\" ' Tell it to import all Excel files from the file directory strFile =...

It depends on what you mean by "automatically import multiple excel files", do you want to click a form button to import the excel in a folder or something else?

I'm not complaining just offering a view point. It's more like a debate, I need to be convinced to differ my view. :) Honestly I can't see many people paying for diamond and I think they should lower the costs. Something more realistic like: $15, $35, $75, would be a better range and I would be...

Is this something that will happen often? You could just create a simple query with criteria being the persons id/number and a date range. Then have a sum function in the value column. It also depends how you want to input the id / date. Is it going to be the same person every time?

Simple answer is yes, you can export to certain ranges into excel. A lot of people have had similar problems lately, have a look on the site and you should find some good starting points. If you can't find anything I'll have a look tomorrow if no one helps before then.

That's not true, I'm all for contributing to the forum but I'd want just one option for a person to donate whatever they feel appropriate. For example I'd donate a small amount every time I needed help and got an answer. I feel the amounts are far too excessive, especially for only one...