Search results

Hello i am trying to achieve the following functions with a script without much success, would anyone be able to help? This is my situation: I have a table called tblClients from which i am selecting a client name through a combobox called: comboClientSelect I have a query...

I need the query results to display in table view in my form

Hello, I have the following situation: I have a a table (tblJobs) of job numbers I have a table (tblWorkHours) of work hours, each of which is tied to a set job number. I would like a query to select the work hours based on the job number i select, but i would like to do so using a textbox in a...

Hello, tagging on to the this thread as the title matches what i need I have an access macro that i would like to run on a schedule. I have made a shortcut to my desktop to the required macro, and if i click that shortcut the macro runs exactly as expected (and opens the database if it is not...

Hello all, I have the following situation within my database: tblJobs is my list of job numbers tblWorkHours is my list of hours worked by the various employees of the company, these work hours are linked to a job number number from tblJobs I have set-up a query that effectively acts as a...

Thankyou for all your thought-full replies, much appreciated. Once i have my system going (whichever way that ends up being) i will post it here, if it can be of any interest to anyone..

Thanks a lot for posting the working script on this thread! :D This is (almost) exactly what i am looking for! The only slight difference i need is to copy the query results WITHOUT the column headings? Anyone have an idea of how this could be done?

Hello The_Doc_Man, Thankyou very much for your thoughtful reply. Let me give a bit more background into my situation: My (still small but growing) company has reached the limits of what we can manage with Excel so we need to move to a database system like Access. At the same time we need a way...

Hello, I am building a database system form my company and i intend to use the CData ODBC driver for Google Sheets which allows the (almost) seamless link between a table in access and a google sheets document. Link for info: https://www.cdata.com/kb/tech/gsheets-odbc-access-linked-tables.rst...

Yes, i think that i will have to go with a split form. My only problem with that is that the columns in the table are directly linked with the fields that are in the main form, but for me i only want to be able to input some of the fields, with the other going to their default values. If i...

Thanks for your response bob! I tried that, and when i do the table only displays the one record that matches the ID from the main form (the other records are not displayed)... I want the entire table to be displayed in the subform, but that the selected record in the subform matches the...

Hello All, I am trying to do something that i would have thought would be simple, but have been turning around around in circles not really getting anywhere, so time for forum question! :) I want to have a form which is to be used mainly to add new records but also want to be able to modify...

Hello All, I am trying to get the following to work: Data input form with the following fields: 1 - CustomerName (combobox from a table) 2 - JobNumber (combobox from a query) 3 - Employee (combobox from a query) 4 - WorkDate 5 - WorkDescription 6 - WorkHours All the above data is to go into a...

Thanks for the really quick responses, (i did not even get time to step away from my computer! :D ) So from what i understand from you, if i get a computer like the one i specified in my original post, set it up on the network and share the back-end file on the network i should be good (that is...

Hi, sorry for not specifying, yes it is MS Access.

Hello all, I will soon (hopefully) be implementing an Access database to replace the existing mess of Excel spreadsheets that are used in the my office to manage our work hours, client info, invoicing, etc. The database is intended to be used by less than 10 people (realistically only 2 or 3 at...

Thanks for your responses, Taking them into consideration and doing further research i am now going as you advise towards doing it all within Access. My only concern is as i described before the ability to freely modify the invoiced information, let me explain a bit more. The company provides...

Hello All, I have an existing Excel invoice template that i would like to integrate with an Access database. In the database I have various fields for client information, and queries to get the data i want to invoice. I am looking for recommendations of how to link the two together, here are a...

Thankyou both CJ_London and arnelgp, Problem resolved. The key thing was using [Invoiced] in the square brackets within the statement. I put that into my original IIf statements and it all works as i originally expected. But thanks to you i also now know how to use the OptionGroup, i am sure...

Thankyou for you quick response CJ_London, What i want to achieve a way to 'filter' a query result based on the Yes/No Invoiced field. But i want to be able to use a form to show Invoiced, NotInvoiced or Both. It is the Both that is causing be problems.... I don't mind doing it using 2...