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 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...

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...

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 =...

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...

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

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??

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

I'm having trouble getting my dates to compare correctly. Dim dt As String dt = Format(InputBox("Enter Date"), "mm/dd/yyyy") For a = lastrowa To 1 Step -1 If (Sheets("active Prior YE").Cells(a, 11)) < dt Then Rows.EntireRow(a).Interior.Color = RGB(255, 255, 0) End If Next a...

What would the code look like that sorted data in all columns based on what was in one column, but didn'y limit me to a range? Not (a1:a2), something like (A:A) but I don't want to sort the title row.

I don't know if this post belongs here or in a forum about excel. Right now I've got an access DB that does some "slicing and dicing" on some data that comes from a txt file. Later we decided that we want to output to an excel file. Would you have the user open up access and push a button etc...

Hello, Is there a command that brings up a browser for the user so that they can browse to a file and I can capture the path and use in code?

Ok, I have a csv in a standard format, it always has the same fields. We always have to do the same routine of complicated sorts and deletes in excel to get certain counts. I want to automate this process. I was thinking access would be the best place to do this. I can import the csv into a...

RoyVidar just showed me how simple it is to do delete query in code. I was using recordsets. I thought I'd try and do an append query the same way, but I'm having trouble finding an example. This is what I got. strsql = "Insert into [table1], [field 1] = 100" This is just a test db. Table one...

Is there a way to get a user's computer name or user name without setting up login passwords etc. I want to be able to automatically log who made an entry through a form.

Hello. I have a form that shows company info. If user deletes a company I want the entries in a table in another acess DB to be deleted as well for RI. I'm having trouble finding the best place to put my code. If I put in in afterdelconfirm the me.company_numeric used is not the company that...

I'm trying to be more efficient with my code. I've got 6 variables c1, c2, ...., c6 I want to refer to the value of these variables in a loop. This is my loop: For s = 1 To 6 c = "c" & s If c <> "" Then SendKeys c & "{enter}" End If Next s I'm getting this...

I have a form that displays personal info. User presses a button that brings up a pop up form that shows certain info: name, address etc. so that the user may copy and paste this information in a usable form somewhere else. Right now I'm using an unbound form with a big textbox in it. Unless you...