Search results

If you don't see what I am talking about, look up help on the Between functions for dates. Microsoft could explain it better than I ever could.

If you are using actual dates: In your query, under your field in the criteria put: Example: Between #1/1/2005# and #2/16/2005# (When using actual dates you must use the # signs to let access know that it is a date). If you are using references to field names: In your query, under your...

I assume you are trying to import the table? Why not import the table and let Access create a new table, name it whatever you want and then add the new fields to the new table. If you don't want to do that. Ensure that the field types are identical to the table that you are trying to import...

Your IF statement is set up looking like it should be an IMMEDIATE IF statement. This might explain the undefined IF error that you are receiving. Try, morning_Afternoon: IIF([TIME]<=12,"Morning","Afternoon"). Hope this helps.

Hi BBinMO, I wouldn't be to concerned with those events not being on the property sheet of your form. Even though they aren't there doesn't mean you can't use them. For example, go to your form design toolbar, then click on the 'Code' button. This opens up your VBA editor from there you can...

It doesn't work for any version of Access or SQL Server that I am aware of. I have never actually run into this problem, but I took a designer class on SQL 2K and one of the big notes the instructor said was that you can not update underlying tables through a view, unless, of course, as I...

Views Are you trying to update the tables themselves or are you trying to update the tables from the form to the tables via the view? If it is the latter then the reason you are getting the error "This recordset is not updatable" is because you are trying to update through a view(query) which...

I'm not sure if this is what you are looking for, but maybe try this. Use the query wizard and choose 'Find Unmatched Query Wizard' then join your 'SUBSC_NUM' on your NEW table and OLD table. Then you can select the fields that you want to display. Hope this helps.

I answered my own question. When linking the tables for the ODBC connection, I needed to check the Save Password checkbox. Maybe this will help someone else.

I am running an Autoexec macro, that runs my maketable queries, update queries and delete queries, then it runs the transfer spreadsheet macro to a folder that I have created on the root of C on my local computer and then the last thing Autoexec does is close my database. I have all this run...

Can anyone tell me where to find the Microsoft Hierarchal Flex Grid Control in Access 2000/2002?

Try setting the CanShrink property to yes for each field on the report (1 - 10). The CanShrink property allows the field to shrink to nothing if there is not information, which removes the total space that the field would have required on the report, which in turn will keep moving the field up...

Try this on the same criteria line: (Between <minzipcode> and <maxzipcode>) or (Between <zipcode> and <zipcode>) See if that works. I think this is what you are looking for, if not, post a reply.

If that is not working try making a text box on the form that is the value of the calendar. When you press the date on the calendar have the text box automatically populated with the calendar value and have that textbox visible property set to no. From there use the text box as the criteria in...

I am writing a database to keep track of medication carts. I have an OLE object box to allow for pictures of the medication carts. Right now I have around 35 records with 2 pictures (OLE objects) for each record. I want to have a user be able to double click on the picture and have it open up...

JustMaybe try an IIF in your control source for your textbox. Write something of this nature: IIF (isnull[textboxname], [labelname].visible = false, 'Do Nothing) textboxname is the textbox that you are checking for null. If the textbox is null, then the true part of the IIF will set the...

If you set the canshrink property of a null field to yes then the textbox will have no size, which means if it takes up no room then the next non-null field will take it's place on the report. Try it, you will see what I mean.

I set the canshrink property on every field to yes. I didn't look into the VBA side since the answer that Rich gave worked. If that hadn't have worked, I would have turned to code.

Actually what Rich gave me was the game winner. Your code would work to hide the text box/label if all I wanted to do was hide those fields. But the thing was I needed to not only hide the null field but also to move the next field (if not null) right up under there. Thanks to both of you.

Thanks, Rich. That worked like a charm, it was perfect.