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...

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 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

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...

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...