Search results

SELECT CDate(Mid([issue_date],5,2) & "/" & Right([issue_date],2) & "/" & Left([issue_date],4)) AS Issue, FROM dbo_polc_t WHERE (((CDate(Mid([issue_date],5,2) & "/" & Right([issue_date],2) & "/" & Left([issue_date],4)))<DateAdd("d",-7,Now())) AND ((dbo_polc_t.zip) Like "452*")) OR...

I get a data type mismatch error. I put the CDate function in the field expression and the DateADD function in the criteria? Do I need to put a format function before the CDate function?

Its a text field

Does anyone know of a function that will change the date format from yyyymmdd to mmddyyyy? I have a linked table to a data repository, I'm using a date field in a query and would like to use the dateadd function to return a certain date range from 7 days prior. I can't get it to run, I thought...

I have a macro running off queries, creating a report set up to e-mail the report. I'm not sure if my recipients have snapshot viewer therefore, I want to send the format as Rich Text. The report will open in MS Word this way, however, the embedded ojects(company Logo in the page header of the...

I have a form set up and would like to have field update to a table when a policy number is input into the form. The fields are extracted from a linked table and are not viewed on the form but need to be written to a table to create a report. I'm confused on the sets to take to handle this. I...

We are trying to get a field to date stamp when another field is changed from a list box field. We have a macro attached to the list box field using the Setvalue action, the expression is Date (). We are getting an error message : "the object doesn't contain the Automation object 'this is my...

SQL has not changed

I have a db i run against Datawarehouse tables. Every week I append records to a table and then run an update query that updates a policy status. This week when i run the update query i get the following message: Operation must be an updatable query. The table is not read only and not other...

I have a DB where I run two queries every week that extracts data from a Datawarehouse and appends records to a table. Then i run an update query that updates a policy status on the same table the appended records are added to. For some reason this week when i try to run the update queary i...

Does anyone know how to put a checkbox on a form and when the check box is changes from blank to checked it puts the current date in that field? Can this be done by formatting the properties or create an event? Or does VB Code need to be written? Any assistance would be helpful.

Thanks for your help. I think I understand the note table structure. I'm confused on how this will allow for multiple notes on one policy? I guess i could put a button for add record to the note table?

I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be...

I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be...

I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be...

I have a make table query created from a linked to a table. i want to add field to the make table query that are not fields on the table. How do i insert a created field? Hopefully this is a basic question.....

Does anyone know how to use an update query however, rather than update the field with a specific value, the field is updated from another tables value of the same field name? This is the sql I attempted to use however, when I execute the statement i get a enter parameter value when it gets to...

Does anyone know how to have a datasheet view in a subform fill the top of the main form? I want to be able to see the records in a datasheet view and when the record in the datasheet view is selected it prefills the top of a form ?

I crated a DB that tracks new insurnace policies added to a system. Earch Week I run an append query that adds new records to a table. I want to be able to keep track of the new records each week. Does anyone know if there is a way to add a date field to the append queary? This would enable...

I created the following update queary to extract data from one table and update a field in another. When I run the query it gives me a prompt for the AGENT NUMBER which is the final statement in the query. I'm sure this is user error....can anyone help? UPDATE MainPendingTable SET...