Search results

I'm working on a database that is quite large. I foreign key that connect all the table is project_id. When I start a new project there a certain table that will not be used for quite some time. I would like them updated when I start the project with the same autonumber that is created for the...

I wondering if anyone knows of an automatic way that changes can be tracked on a form. Ex. The last time a record was updated in that specific form

I'm not familiar with using dlookup and I'm having some problems. I have a form with a project number. the project number relates back to a table that has organizations and project number -the table name is Project I need the organization name to appear on the form. The where clause of the...

I working on form that I would like to prompt the user if they would like to select close on a drop down box if another command is selected in another drop down box. So when a user exit the form it asked if they would like to close the record ( select close on the drop down box) Private Sub...

Thanks I should have known that my brains not working today ! One more thing - To save my value from the text box called HB# into a field, any advice ? Thank you so much.

I have a formula "HB" & [autonumber field] & "05" to create a number for my record ie HB105. I want this number to save into my autonumber field. where could I enter this formula so that when a user enters info in the record its saved in that field ?

I'm using a query to look up report criteria by type, response etc using a query to search value in a field ex [Reply]=[Forms]![Form1]![Cmbreply] Or [Forms]![Form1]![Cmbreply] Is Null I'm trying to work a month look up the problem is the date is set July 25,2005 and my field is searching for...

I'm already using autonumber in the same table. It's a pain ..

I working with alot of records and would like to assign file number in the patter 001,002, 003 ... any ideas Thanks

I working with alot of records and would like to assign file number in the patter 001,002, 003 ... any ideas Thanks

I figured it out poor choice of summing on my part thanks for responding

They are exact matched thats whats troubling me, Every field lines up the only variance is in the unit number which is a seperate field and not included. So one housing provide say John smith has 4 different units all 1 bedroom with the same features at one address 10 willow, willow appears in...

Any Help would be greatly appreciated. I have a report that has a field for a housing provider and then the address of the building. A provider may have many unit at one address.In my report I want them to group together (roll up) if the have the same address. Instead the report lists every...

I have a query based on two combo boxes in a form that links to a report, it works fine. What I want to be able to do is select criteria from one box and if the other is blank have it include everything (right now if one is blank the report will be be blank) and vice versa. Any suggestion on...

Thanks for the help I really appreciate it Im not much of a DB designer sorta of forced into it for this project I seem to have on glitch two day and 5 days work fine but the third case of 10 includes the weekend in its calcualtion ex June 16 results in june 28 due when it should be june 30 b/c...

I have a combo box that when selected autofills a due date box. I forgot that I needed to skip weekends and only count business day. For example if you choose standard it adds 2 days to the date but I need it to skip weekends. Any help would be greatly appreciated. Private Sub...