Search results

what if you automatically imported the spreadhseet to a temp table, then exported it to the same file, and then imported it back? Would access format it as text when it exported the file, thus "fixing" the problem when it imported the second time? just a thought.

actually, Solved the problem. Just needed to refresh the mainform from the popup form instead of requerying it.

yeah that would work. I know nothing of Excel VBA, so I'm not sure how to do it in excel. you could take len( ) and if it has four characters, insert an apostrophe. THat may work in your case. Or, it may import the apostophe if you do it on the access side. -this may have to be done through...

okay, -First, I am on a SQL Server. I have a form whereby the user can click on a form and a pop up form will be displayed for that record. The user can make a selection on the pop up form that will run an update query on the table underlying the mainform. And, indeed, this is what happens the...

I still haven't found anything-not in an automated transfer spreadsheet method at least. If you only have one field that does this, you can sort it dwcending in Excel-but if you have multiple fields, thie will not work-At least for me.

thanks that did the trick. I wasn't aware that the maximize command maximized all forms. Good to know.

Hi, I have a form that is maximized on the Load event. On this form, I have a button that opens a form based on a query which is in turn based from data entered on the main form. My problem is this: I want the secondary form to be a smaller size when it is opened. I have set the size on the...

oh, of course. That was a rookie mistake. Thanks.

does somebody know of a good tutorial on conditional statments in VBA? Some times I write them and they work. Other times, they just run as though the condition is always true, no matter if it is or not. Does anyone know of a good tutorial or can provide me with a "lighbulb" reason for why the...

worked like a champ. Thanks a lot. I guess "= Null" works some of the time. Appreciate the help.

please ignore the End Sub on the same line on the last line, that happened when I entered it on the thread.

Okay, I have a conditional statment that works, but runs through the "Then" and "Else" cases no matter what Me.Check_Field equals. I get the Msg Box no matter what. I'm probably doing something incorrectly, but I've done conditional statments this way in the past and they worked. I have pasted...

Thanks, What I figured out was I could have the date field as a not in list disallowed combo box and run it off of a query that did not include previously requested dates. Not ideal, but it works and is better than spending time trying to figure it out when there may not be a way to do it.

Okay, here goes: This is a Puchase order change request form whereby the User can change select a PO and change marka new date for the PO. This gets recorded to a table called PO change request. The PO can be changed multiple times before it is shipped. Each individaul request is copied and kept...

you're right. That does work. Basically, I'm trying to highlight a single field red if the value is over a fixed number. The conditional formatting solves this problem.

yeah, you're right. If I got rid of the shadows and made every field white I could get it to look pretty similar. Thanks. Honestly hadn't thought of that.

Thanks, The users want to go with datasheet. What do you use to change the color of the lines? I tried changing the border color on the field but that didn't do it.

I have a subform that is in Datasheet view. what I want to do is format certain rows of the datasheet with different backcolors. When I write it in code or simply change the backcolor in the field in design view, the field in design view changes but the datasheet remains white. Am I wasting my...

Thanks for the suggestion. Worked like a charm

Thanks, I have a feeling that's what happened to me, too. I would be curious to know what those characters mean. I googled one and it looks like Japanese. I just wonder how that would be possible. Coincidence? Access is strange (i'm still new at it)