Search results

Hello there. I have a query with 3 text fields; Title, FirstName, Lastname. I've concatenated them with Fullname: [Title] & " " & [Firstname] & " " & [LastName] so it produced eg Mr John Smith. Slight problem is there isn't always text in all fields and I get redundant spaces. Not a major...

I'm using the DateAdd function and also Date + 14 etc and DateAddW (user defined, provided by MS) The problem is as soon as I try to add more than a few days the results I get are very odd. For example if I add 10 days I get a result that is months in the future, if I add say 14 days I get a...

Hi, Just a quick one. I want to store currency amounts but not use the currency format. My DB is set to use all currencies and provide in all currencies. Do I use the SINGLE data type? Cheers, Dan

I have a calculated field in a query that provides the names for task lists and the number of tasks in each list within parentheses; NameCount: [TaskListName] & " (" & DCount("*","tblTasks","[TaskListID]=" & [TaskListID]) & ")" This works nicely and provides; ListName1 (2) ListName2 (10) etc...

I'm adding data to several tables with a single form using INSERT SQL and the Dmax method to sort relations. On one of the tables there is the potential for duplicates which I want to avoid. Please can someone provide an example of DMax or DCount or other method that I can use to decide...

I've almost completed a little task manager add-on for my main database. It's nice and simple but I want to add subtasks so a user can break a main task down into logical steps. The question is, should I create a new table for the subtasks or should I use the existing tasks table and create a...

Got to the stage where I'm creating and accessing folders via my db. Is there a number out there for what is deemed a sensible maximum number of subfolders in a folder? Cheers, Dan

How can I return the ID for a newly appended record without using a LastRecord type function? I'm not even aware of exactly how this is done yet. I feel if I request the ID of the last record added it could cause problems later down the line with multiple users and I would like something...

It's looking rather exotic at the moment; "��=ks������f;��6������IN|��n�6����P���x���ò�ɿ������.r�V��ؙi�t�dE� � �����g'����`�.߼�|�~8��sexdyqh1���#K��/U���Cs�x��������g��xҿf���� T=� � B�;�q�k��0�WUد���Z�aZ�2�D��tB�^̎GD{%���?�aMØ�}>G�+"'�A,�o1G
���<���$f3(�ﲾ�Y��...

I've just linked my outlook inbox and it contains a "From" field but no email address field. The idea is that I would like to include a continuous form of recent emails from a contact in access. The only way I can filter the linked table is with the email address but it's missing. Does anyone...

Hey there, I use this tool online a lot as part of my work; http://www.textfixer.com/tools/remove-line-breaks.php It would be good to add this functionality to my database for speedier input from PDFs and so my users don't have to navigate online. Any suggestions on how this can be achieved?

I have looked for hours trying to find a working solution for something that seems so simple. I have a form called Enquiries In the Enquiries form is a subform called enquiry notes I have added an unbound textbox so users can add notes to enquiries Notes are stored in a table called...

Hi there, I'm in the process of making a database to handle ad campaigns. I have a creatives table logging the creatives; Fields; Size Format Theme Colour Wording I have a campaigns table logging the campaigns; Fields CreativeID Network Country Status The client provides me with a landing...

Hi there, Available from Access 2010 is the sample; "Desktop Product inventory database.accdb" It contains some features I'd like to learn about and implement into my project but I can't access anything in design view. How do I change this? I have tried and searched but nothing useful has...

My name is Dan, I'm new to db development and I'm currently working on a database for a small media company. I'm looking for some help with a number of things and hopefully at some point, I'll be able to help others here :)