Search results

Hello, I am trying to create a listbox that shows "calculated" dates for a two week payroll. I have a field in a table that is set to a start date (05.31.05) and another field that specifies the number of days between dates (14). I would like set a listboxes recordsource to show the start date...

Funny! Yeah, I tend to do things inefficiently until I find I better way. Usually things take a week to design and then I find one command that does it for me. It's all about learning, right? Thanks for your input. Paul

There I go making up my own terms again Thanks, llkhoutx. I usually refer to the QBE as Query Builder. Did I just make that up? I thought the QBE was some mystical world or something for awhile. That must've really sounded stupid, hehe. OK. You suggest creating an append query. But by...

llkhoutx, Thanks for the reply. I will look at append queries to see if they would work. I'm out of practice and may be missing something. I think the append query would do it, but I'm looking for an easy way to select all the fields(minus the autonumber) for one record and paste them into a...

Hello all, I would like to design a query that selects all fields from one record and pastes them all into a new record (in essense creating a duplicate record). I've read that using a QBE is what I need. Can some one direct me to where I might find examples or more information on QBE? This is...

Got it! Contrary to the many searches I've done on this problem, I think there's a solution to this using the SelTop and SelHeight properties for a form. Thanks again for the help folks. Here's where I found it in case you're wondering.

Thanks for your reply, WayneRyan. I'll look over the test.mdb in more depth. If I can't get a subform to work then I'll definitely try using a listbox control. I have an application that does what I've described previously using a subform. I don't know how it works, but I think it can be done...

Hello all. I'm experienced in VB, but I'm having trouble referring only to the selected(highlighted) records(rows) on a subform. I would like to select multiple subform records(rows) and use a recordset to loop through the subform recordset and edit those records that are selected on the...

Why would the append query be better? That was quick! Thanks for the reply. Can't this be done with the TransferDatabase method? I'm just in testing(playing w/ this method), but eventually the actual tables will be located in a separate database entirely. The way MS puts it, TransferDatabase...

Hello all, Can I use the TransferDatabase method to export a table's data into a second table without altering the second table's structure? I have two tables with matching fields only the second table has an additional field. I would like to export the data from the first table to the second...

try & Format(mySum, "currency") &

try [lname] Like "*"& [Forms]![pending].[candidate] & "*" hth

Have you tried... stDocName ="Forms!" & Trim(stDocName) & ".DOB" I think that's right. If that doesn't work to test stDocName, try the following... 1.)drop another textbox on your form(txtTextbox) 2.)in the code put b/4 the code that gives you the error... Me.txtTextbox=stDocName 3.)run the...

2nd ?...try select DISTINCT... in your query to give you unique values... Your first ? can be achieved several ways depending on the complexity you're comfortable with. I personally would try using a datasheet form with totals on the bottom. Then the user can filter the form by clicking on the...

Thanks for your responses folks. I'm going to test the Len(TextString) and then use Select Case. This may be more prone to causing unforseen hang-ups, but that's what Error handlers are for right?(joking, kind of) Until I can find a better way.

Thanks Travis. O.K. that's going to make things so easy. I've never used make-table queries, but there's a lot of time to figure it out. Now that I know that it can be done, I can envision how it's going to work. Thanks for giving me the means to get started.

Thanks for your responses. Ghudson... How would you "test" the data, as you say? If it were possible to do so, I would know that the user is scanning a license and not searching another field. The only way to do so is by checking what kind of format the TextBox data has. Your 1st suggestion...

Recordsource based on every date Hello all, This may be a really dumb question and I'm no stranger to those so here goes... I would like to create a scheduler calendar on a form from scatch perhaps using a subform(not an ActiveX control). It will be based on a table with appointments and...

Hello, Can I evaluate the Format of the Text entered in a Textbox? I have a search box on a form that a user can enter various information into to search on...(driver license, phone#, etc...). Because one scenario causes problems, namely license# formatted "a\-aaa\-aaa\-aaa\-aaa\-aa"...

I changed the extension to .jpg and it works now. What a day! imgEdit1.SaveAs "E:\Pictures" & LTrim(Left([LicenseNumber], 13)) & ".jpg"