Search results

Then why not use a proper autonumber field? I'm sure there is a reason, otherwise you wouldn't have gone to the hassle of doing it manually. I assume it's a formatting issue, i.e. you don't just want "1, 2, 3, etc", can you give a couple of example numbers in the format which you use?

And is it the order on the report or in the query? Because reports have their own sorting which overrides the query sorting.

I tend to set my date criteria on the fly either vie paramaters or references to controls on forms. e.g. Between [Enter start date] and [Enter end date Using the above in the criteria will prompt the user to enter the start and end dates each time the query is run. This has the advantage of...

I'd use the first method (or a recordset returning the top 1 result, sorted by the field in question - this gives the same result of teh highest number currently in use). If possible you want to calculate the number as early as possible and save it as soon as possible. This reduces the...

Further to above, click on the subform object once to get the properties for the subform object, rather than the form it contains. The subform object properties hold the link field properties mentioned above. *This may already be shown in the attachment, I didn't check it*

Firstly, I think you will need to set the focus out of that subform. I don't believe it lets you hide the form you currently have active. You should be able to do that with something like "Forms!frmMyTasks!ControlName.SetFocus" (replace bolded part with the name of the control on the main form...

I assume the table has some unique field (an autonumber or perhaps an emplyee ID / payroll number)? It would be better to use that as criteria rather than a combination of forename & age (it's possible to have 5 Dave's all born on the same year unless you have strange hiring principles!)...

SQL is very widely-used, there are bound to be at least thousands of learning resources! Books, websites, courses, and forums like this one. Keep in mind that this forum is a learning resource and if you learn something after asking for help here then it's all good. :) Personally, working...

No problem. I guess my query builder advice wasn't detailed enough, I was expecting the expression builder to do the criteria for you after you browsed to, and double clicked, the correct control on the form. See attached screen-print.

Here's a site which details various ways to customise fonts in html: http://www.tizag.com/htmlT/font.php Looks like this should do what you need:

I would expect the criteria to be something like: WHERE Details.Age = [Forms]![SearchForm]![txtAge] As in, field = control. Surely Details.Age = Details.Age will always be true? :edit: Guessed form & control name highlighted red to ensure no confusion. I don't know your form or control...

I guess for the same reason it's possible on internet browsers. You may not need it each time you google but if it's something you google often then it's nice to type the first couple of letters then press the down arrow instead of typing everything. As you say, saving it to a table but...

If it's a lookup then it's data in another table which you are saving more than once? Why do you need to save the same data a second time in another table? Can't the front-end just perform the lookup in its queries based on the new table?

Create a query as the recordsource for the combobox. It should be 2 column, 1 not returned but just used as criteria (name & gae, age is criteria only). In the criteria cell for the age column right click and click build (or click the ... to the right of the cell after clicking into it)...

Glad you got it sorted. :)

Technically, since encryption is just applying a mathematical algorithm to a string of characters, you could create your own VBA functions to encrypt & decrypt passwords. Put these functions in an external database with links to the table holding the passwords and anyone accessing the BE...

Given that batch imports aren't always the same you have 2 options, start from scratch or find some existing code and modify it. Which way you decide to go should be based on how well you read code. If you aren't going to understand existing code which tyou get from another site then you won't...

The SaveAs method allows you to specify the file format: http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas(v=vs.80).aspx

If the import procedure is always the same (e.g. always capturing A1 - J10) then you could create a table of the spreadsheet file names and loop though a VBA-based import process. However it's hard to say without knowing more and to be honest I'd likely do it as a trial and error kind of...

I hate to disagree but the "solution for the table" was to add & populate a date/time field. That makes the fact that you have the month stored as text moot as you can now use the date/time field. Therefore I can only assume one of the following is the case: 1. You have not added &...