Search results

If you have dates in your database you should be able to make a query with SQL DELETE tablename.* FROM tablename WHERE tablename.date < DateAdd(m,-1,Date()). DateAdd will subtract one month from the current date. The SQL statement above will delete all records older than one month prior to...

If you have the start date and end date boxes on your form then just add two fields to your query, one with Forms!formname.formstartdate and one with Forms!formname.formenddate in the control source field. Then in your report you can pull in these fields. You may be able to pull them directly...

fixable So you have multiple entries per vessel and you only want to see the ones with comments and/or concerns? If this is the case you need to put Is Not Null in the criteria of the comments section and the concerns section. If you only want entries with both comments and concerns put these...

Do you mean that if the "bad stuff" field is blank, the report still adds a section for that vessel and you don't want to see anything for that vessel if there is no bad stuff?

If you create a form with an unbound text box where you enter the membership number, or starting number, whatever it is that you are trying to update in the members table and then make a button that, when clicked, runs the update query and makes the report. Then all the user has to do is open...

I got it working now. Thanks for that link and all your help.

I've got the files made, when I run the .bat file it brings up a DOS prompt for a split second then it closes and nothing seems to happen. My FTPdirectory is ftp://www02.commandcenter.com. Is this the directory, or is only part of this the directory? Should the file name include this directory...

I need to import a file from an FTP into an Access table. I do know the exact file name that I need to bring in. How do I modify the code above to do this? I have no experience with VBA so any help that I can get would be great.

The SQL statement worked fine. Simple UPDATE SQL. I appreciate the code, but that was way more complicated than what I was looking for. It is just a text field that either has "Open" in it. For some records I just need to change this to "Hold".

I want to make a button that will find a particular record and change the value of the field. I was hoping that there was some way to do this through a macro rather than making a new query. With the SetValue action you can do this with a form etc. but it will not allow me to do this for a table...

When I removed the input mask from the form and just typed the phone number as a general number it ran fine. I guess I'll just have to deal with it.

Thanks for the suggestions but they still didn't work. Is there some reason why it isn't recognizing the data is there?

I have a form control with the input mask on it for a phone number. I am using an append query to append the information entered in the form to a table. I need to pull two fields from a linked table from another database. What I need to do is be able to compare the entered phone number in the...

I have a form control with the input mask on it for a phone number. I am using an append query to append the information entered in the form to a table. I need to pull two fields from a linked table from another database. What I need to do is be able to compare the entered phone number in the...

Figured it out, thanks

I have a report based on a query. When I run the report I get a pop up that says "The specified field [FIELDNAME] could refer to more than one table listed in the FROM clause of your SQL statement. Is there some way that I can specify which table I want it to come from? The field is already in...

Is there a problem with using an IIf statement in the criteria of a query. If ther isn't then is there a problem with using a Between...And statement inside the IIf statement. Or, does anybody see a problem with this IIf statement being in the criteria of a query...

What do the & symbols mean?

Does the # have some significance or is it just a placeholder?

It is bringing back something, sometimes it is the blinks from the previous date and sometimes it is way off, thanks for the tip, I'll work with it and see what I can do.