Search results

I am still learning to use recordsets out side of ASP and still having problems with it. I want to update the "Jobs" table with (for now) static data. Here is what I have so far: Dim rsCOD As DAO.Recordset Dim strJobName, strJobNumb, strLocation As String strJobName = "Talismanic" strJobNumb =...

Well it didn't take very long for them to ask me to modify the output of the application. I thought I could figure it out but that was not the case, so I am back asking for more help. In my previous Brain Teaser post I only needed to evaluate one text box with one output. Now I need to look at...

This is a add on to my brain teaser, I can make sure that something is entered into the text box with this: If IsNull(CodePick) Then strEval = MsgBox("You must include a value", vbOKOnly, "Entry Error") Exit Sub Else Now is it posible to limit the entry characters to only B, H, X, D...

I have strings that can be any combination of the following: HHHHHHHD HHHXHHHD HHHHDDDD I need to be able to parse them into meaniful messages to the user. This is very complicated so I am going to post the rules along with this (It's a brain teaser). Overtime is represented as a eight...

Our payroll week ends on Saturday and Payday is Thursday. I am looking for a way to get the date for the next Thursday and Saturday following the current Date(). Any ideas?

I am trying to catch empty fields in my form with this: Private Sub PayDate_BeforeUpdate(Cancel As Integer) Dim intQuest As Integer If IsNull(Me.PayDate) Or Me.PayDate = "" Then Me.PayDate.BackColor = vbRed Me.PayDate.ForeColor = vbYellow intQuest = MsgBox("You must enter a value...

I have a form with 15 textbox controls, 10 of them are required fields. I have a button that I am using to update the table and start a new record. Now I want to check for null values in the 10 fields before the data goes to the table and then mark the "bad" records to the user by turning the...

Isn't there a way to clear all the objects in a form using something like this: For each object in the form clear contents. I haven't been able to find anything in Access help but I have seen this done with other scripting languages so I wonder if it is possible with Access.

One of the form wizards that Access makes has a yellow background with yellow fields. When any field gets focus it turns white, I am trying to do the same thing in my form, anybody have an idea how it is done. I know that I could do it with code but there is no code included with their forms...

I have never been able to figure out how Access handles forms. I have made a form that is exactly 2 1/2" in design view. There is no empty space on the bottom of the form but When I switch it to form view Access adds another 1" or so of blnak space to the bottom of the form. How do I make a...

I am having trouble getting this DCount to work right. Here is the critera that I am trying to check for and how. Tables name is Rates Fields inside table are JobNo, Name, Time and Class In the form I am working with I want to do a Dcount when txtPW = "Y" and the Class is not "Nor". I know...

I am having some problems figuring this out. I want to remove two spaces from a string if they are present. The string is in a table that is imported from another program which won't allow me to make the changes there. The typical string I am dealing with looks like this K345-, but the...

I am trying to change the text of a button when the mouse pointer moves over it. Does anybody know of a way to do this with Access. I would like to change it to magneta when the mouse is over it and back to black when it isn't. I just can't figure out how to capture the event and then let go...

This is more a Visual Basic question then it is a VBA question but I am hoping some one here can help. I have a device on a Windows 2000 machine that I need to be able to enable or disable on the fly. I was shown a solution using Send Keys like this: Set WshShell =...

Round number up to nearest whole number? I have a field in a query that I want to round up to the nearest whole number. How do I do this? Here is the field: Numb: [MonTimesEmpPay]

I need to check a textbox for a - at the end of a string and if it is not there, add it. So if a number is entered as K433 I need to have Access change it to K433-. Any ideas?

I found several posts that showed how to open a specific spreadsheet with the shell command but I could not get it to work. What am I doing wrong? Dim strFilePath As String strFilePath = "I:\Workers's_Temp\ImportSpec.xls" ' I tried it like this also: ' strFilePath = "I:\Workers's...

Does anybody have an example of module that will simulate an FTP program. I need to FTP a text file from Access over to a Unix server.

I must be missing something simple here becuase I can not figure out how to show control tips on command buttons without setting focus to them. I am thinking that I need to use the Mouse Move Event but unless there is a way to set it for the entire form I would need to set it at each command...

Is it possible to rename table field names with code. I have a spreadsheet that is beeing imported from Excel and I would like to set the headers once the table is imported into Access. I know that I can have Access assign the first row as field names but that approach will not work in this...