Search results

I run a small business. I started designing a couple of databases some time ago and never finished them. I am still using paper based system and sick of the paperwork. Can someone finish my half done databases for me? I am happy to pay a reasonable fee. I think someone who knows how to write vba...

Hi, I am looking to make an invoicing database. I create 30 invoices a month. each client gets billed the same amount each month (for example Customer A gets billed $100 every month, Customer B gets charged $200 each month). Only two things get changed on the invoice-'Description' (for example...

Hi, I am making an invoicing database, So far I have the following tables & fields. tblInvoices invoice no (autonumber,primary key) invoice date (date) Description (memo) amount (currency) tax (calculated field) total (calculated field) customerID (foreign key) tblJobs Job Id amount customer...

Hi All, I have an asset db. (it is attached) - - Access 2003 File It has two forms 1) Assets 2) Maintenance I want to have a button on Asset Form which opens Maintenance form (i can do this myself) but how do i pass on "AssetID" to maintenance so i don't have to type it into Maintenance form...

I have designed 2 databases. in both of them i had lookups (e.g to select Company name from combo box drop down) The thing is, in actual table it only saves reference number to the lookup NOT THE ACTUAL VALUE. (e.g. if i select Microsoft which is under Company combo box drop down, it saves...

I have 4 tables in my Asset manager database. 1) Desktop PCs 2) Monitors 3) Locations 4) Company the tables LOCATIONS & COMPANY are lookup tables for DESKTOP PCS & MONIOTORS TABLES. - see image and database attached Pls Note: I still need to make heaps of changes in the db. IS THERE ANYWAY I...

I have created a Issues database for my company. Everything works great except when i try to close the Issue Details form (frmIssueDetails) it gives the following error. I can't figure out what that is & how to fix it. I copied that macro from a template from Microsoft website. Can anyone...

In my db the look up fields show up as numbers. for example i have a look up field called "company" and i have two companies in it (Reddot & Thingz). But on report they come up as 1 and 2 instead of their names. The db is attached. If anyone knows the solution, please help me. Thanks!

Say i have two tables 1 = computers (it holds info about the computers) 2 = Repair (this table holds only the PCs that are under repair) I want to be able to move one computer record to Repairs table as soon as i select that "this pc is under repair" on a form. So it does not show up on my...

Hi everybody, I am designing PC inventory database. Butbefore i do, i wanted some suggestions for my reports. I want to be able to run the following types of reports from my database. 1- I will have a lookup table that will allow me to enter computer's condition (for example New - Good...

I have an Incident Management Database. I want to create a query that finds all the information about one incident that is open in form view. I MEAN ALL THE INFORMATION - EVEN FROM RELATED FIELDS. My pictures say it better. Feel free to ask Q. Thanks for looking. Here's the db attached.

Hi, I am trying to create incident mnagement database. in the main form (datasheet view) of my database i am able to click on a record to open it in form view & edit it & when i close it, it saves the data i entered & shows on the gridview straight away. I was able to do it using vba code &...

Is there any way you can specify the size of a datasheet? Say the datasheet opens up with 600x800 size? or 10cm x 15cm?

I have a db. it's attached here The problem is. The hyperlinks to another form in the same db work on the top two hyperlinks. But the hyperlink set on the tabbed form does not work. Is there a solution to this? THE GREEN + SIGNS IN THE DB are the hyperlinks. Thanks!

i have three questions this time. 1) I have a form that is sort of lookup form (users can enter data into that form & that data then will appear in main form in drop down box. WHAT WOULD I NAME THAT FORM? Is "fdlgIncidentType" proper name? I couldn't find one in naming conventions. - (I have...

I have a list of incidents in my Incidents Management Database. It comes up as a grid view when users open the database. This is what it looks loke (paste the following into address bar of your browser. lh5.google.com.au/snehal.dabhi/R8oc22J_RfI/AAAAAAAABz0/bbIkCzg5whk/image001.png I want...