Search results

Good afternoon, It's been years since I've been on the forum and just as long since I've used VBA so I'm starting from scratch on a project. I'm looking for a way to use VBA and Active X check boxes to move info from one worksheet to another in the same spreadsheet. In my example I'm taking...

There used to be a site that basically took snapshots of websites so that even after a website ceased to exist you could sometimes find it on there. Anybody ever seen it, know what it is? Thanks

I've created a query by form such as Jon's example here http://www.access-programmers.co.uk/forums/showthread.php?t=103312&highlight=query+form but whenever I open the form I get parameter boxes asking for data AND one past that after I input the data on the form and run the query I get the...

Does anyone here know PHP in depth? Any good PHP forums out there?

This is the first time I have looked at this so please excuse my ignorance and the many questions that are sure to follow. I also know that this would be better suited to a db of some sort but due to manpower cutbacks we can't convert this at this time. I need to look up data related to a key...

I can't get this IF statement to return correctly. I have a field that can contain 4 answers: MP, MP1, MP2, or blank. If MP return "Not Assigned" If MP1 return "User 1" IF MP2 return "User 2" If blank return blank =IF(C8="MP1","User 1",IF(C8="MP2","User 2",IF(C8="MP","Not Assigned",""))...

I have a database that if I set the option to compact on close it is creating a default (db1.mdb, db2, db3, ect.) database copy. It does not do it if I do not compact on close. The only code I have is an Autoexec module. Option Compare Database...

For the Florida people (Vass / TessB) or others with experience. I am going to be in Florida during the next Space Shuttle launch. Specifically I will be in Sarasota / Siesta Key. I don't want to drive all the way to Cape Canaveral so in what way could I optimize my launch viewing. I am willing...

I have data in my db that is not updateable and I want to add some fields to enhance it. Presentation to another group of people to data entry is where I am stuck. Can I present it in datasheet view keeping in mind that the data must come from two queries (one set that is not updateable and one...

I've got some speaking (i.e. no music) cassettes that I am copying to my PC and I need some help. I am using Roxio Media Manager 9 to capture the audio. I can burn with MS Media Player, ITunes, Roxio or basically whatever is on my pc. 1) I am recording at 128kbs CBR in stereo at 44.100khz, 16...

This is a real silly question but Access' action irks me and if there is a solution, I want it. I have a dropdown combo box where the file number is entered to pull up the record. Because the sytem is thinking ahead of you it is prefilling the box with the record it thinks you might want (i.e...

Is there a command line argument to open AND close a db? I am running a schedule task to open a db which has an autoexec macro but I don't want the db to stay open after running the macro. Or is there a close db function in a macro? I see close form but not db.

I am trying to post a voting poll in a Goggle Group so that group members can vote on an issue. I know you can create a voting poll in Outlook but Google Groups isn't a MS Exchange server. Has anyone ever seen one created in Excel. I want to list the possible voting choices and have a single...

I have the following code which allows one user to only access some fields in a form and it works fine. Private Sub Form_Open(Cancel As Integer) Dim UserLoggedIn As String UserLoggedIn = CurrentUser() If UserLoggedIn = "userid1" Then PendingDate.Enabled = False I need to add another user...

I have too many rows (16,600+) rows in a table I am trying to export to Excel using the following code. Option Compare Database '------------------------------------------------------------ ' Autoexec ' '------------------------------------------------------------ Function Autoexec()...

Wondering if anyone would be willing to take a look at this. I'm wanting to print this on a T-shirt at about 8"w X 5"t. Is there enough here to work with at that size or will it pixelate? If it can be worked with I also want to change Creamsicle to Dreamsicle. The text feel can either be...

I’m trying to modify an existing SQL query that calculates actual working days between start date in tblECN and end date in tblECNDetail to do the same between start date in tblECNDetail and end date in tblECNDetail (same table). Where I’ve gotten into a bind is with the joins of the two tables...

A long time ago when I was first learning Access I named one of my fields "Part #". Now I need to refer to this field in a module but it doesn't like the # symbol a part of the name. This field is in numerous modules, reports and queries. Do I have any option that is good versus the one I think...

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history...

I have two fields the have differing dates in them. I need an action query to make the date in one field the same as in the other. I have thousands of records to do this to. Is there a way via an action query (update?) to do this or does it have to be an SQL statement query?