Search results for query: *

I need to have my database done in 2 weeks. I have a version I want to get on the floor so that users can start using it and error checking it. What is the best way to get a version out to them, but keep a version I can work on? I want to be able to migrate the data changes the users make to my...

I'm running xp, ok I'll give those a shot, thanx.

I used to watch dvds on my laptop, starting about a week ago I haven't been able to do this anymore. about 15 minutes into a dvd playback gets really choppy. I don't know much about troubleshooting this sort of thing. I do know that my processor gradually climbs to 100%. I've tried closing down...

the code below works perfect unless the capital and lowercase don't match on otherwise identical words. Any advice? Sub compareyears() Dim i, j, k As Integer Dim prev, curr As String prev = Sheets("data").Cells(2, 1) curr = Sheets("data").Cells(3, 1) For i = 2 To...

UserForm5.Show Application.ScreenUpdating = False userform5 is a form that say "downloading" when info is downloading into spreadsheets I don't know if application.ScreenUpdating = False is giving it time to load all the way, because the form comes up and is whited out is there a way to delay...

I thought about that, but that's not exact for obvious reasons. It does work if I round to 2 decimals. let me ask: why 365.245 and not 365.25?

how do i get excel to calculate the exact difference between two dates? datediff() is wierd, the diff between 12/31/2001 and 1/1/2002 is one year. months is similar where it's possible for a difference of one day to equal one month. I've thought about converting from days, but then you got leap...

thanks validation is nice

changing my final step from 2 to 3 seems to do the trick. Anybody see a problem with that?

I have a problem with the following code. this code looks for highlighted rows and moves them to the top. It works great unless only one row is highlighted. I get a paste error when j=2 and iInsertedrows=1 and then lose a row. The highligted row moves to the top, but a row dissapears. j =...

allright thanks. I'll give that a shot.

I think I see what you are saying. You are saying pull from the spreadsheet the values that were written to it by the userform. ????? Unfortunately, the values aren't written anywhere on the spreadsheet the values entered onto the form by the user are used to select rows before a certain date...

Ok I have an excel "template" with some good macros built in. The user interfaces with the "template" through a user form. The form has textboxes that the user fills out and that excel uses for sorts etc. After user enters in textboxes and clicks the submit button excel runs macros and color...

Thanks man, you gave me enough info to solve my problem.

does anyone know how to change the macro security level for access 2002?

for access 2002?

ok, interesting, I'm trying to find out where to check my security levels on both. I think I've found it in excel pretty obvious, all I see in access is the user and group stuff. I haven't set any of that up. Any advice?

I've written a nice spreadsheet full of macros of code to help us here at work. Nobody else can open it on their computer because security is set to high. I've written a database full of macros ad vba and everybody can open it just find. Why one and not the other??

thanx

what would the vba code look like to add a tab to the tab control on my form? Thanks.