Search results

How do I go about deploying my MS Access Software that I build. Especially for people who don't own Microsoft Access. I have the Microsoft Developer Network CD's and I have MS Access Runtime. I just don't know what to do. Any suggestions. Thanks

How would I go about trying to find the number of letters of a word. In my database I have 900,000 words. I split each word into it's own letters using "MID(theword,2,1)". I have 24 fields. Letter1, Letter2, Letter3, and so on. What could I use to send the number of letters to a text box on my...

I have 24 fields on a form that I need added together. I am doing it through visual Basic. However instead of adding the numbers it literally adds them. Example. if the fields are, 2, 33, 6, 8, 5 The output is 233685 instead of 54. Can anyone help me out of this dilemma?

I want to use a command button to set a value of a text box to "Donors" when clicked. Does anyone know the code to do this. I thought it was this: Set Me.RepTitle = "Donors" but this didn't work. Thanks for any help!

How can I make the Switchboard form open up in the middle of the window each time the Database is opened and minimize the DB window.?? Thanks,

I run a macro that uses the "TransferText" function to export a query. I have to tell the function where to save the file exactly and with what name. How could I go about giving the user the ability to save the file with a different name? We are going to be exporting the query many times with...

If I have someone entering in a bunch of entries through a form, how could I not allow them to enter duplicate records based on the first name and the last. Thanks,

I am reading data out of a query with 3 fields: precinct walkingaddress walkingnumber I want to print data labels that show the Precint, WalkingAddress - which is actually the street name, and all the WalkingNumbers. I can do this using a regular report with group headers but is there a way to...

I have 100 text files to import into a single database. How can I import them all instead of doing each single one? Thanks, Josh

i have a database with a million records. out of the million records there's 50 different precincts. I don't want to scroll through the million records and write down each different precinct. Is there a way to run a query and pull off 1 of each of the fifty different precincts.

How would I set up a command button on a form to open the "filter by form" dialog box. Anyone have any ideas. I thought about using "SendKeys" but I don't really know how to use this function. Can anyone help me?

When access starts up with my database. How do i minimize the window with all the database names and show just my switchboard. Thanks! Josh

I am importing a CSV file with 700 records using a macro function "transfer text". When I import the file, it only shows 278 records. Does anybody have any idea what is going on?? Just any idea you might have because I am clueless!

I have two tables. 1 large table called "Voters" and 1 small table called "Import". I want to update "Voters" from "Import". It should know which field to update by a field in both tables called "VOTERID". Can anyone tell me what I need to put in the "update to" part of the query? Thanks

I have a form uses a bunch of different filters that are saved into the (Me.Filter). I need to transfer certain fields to a comma delimited file based on the (Me.Filter) criteria. Does anyone know how I can do this. You can't do it using the (Transfer Text) Macro because you have to define a...

I have a split database in a folder on my c: drive. I want to move the database to another folder, but it keeps trying to find the data from the other folder. Can anyone tell me how I can change the data source to point to the new folder?? Thanks so much.

I tried the transfer text and it worked perfectly except for one thing. How do I get the "field names" to be the first row of the newly created .txt file? Thanks

When I export out of Access, it doesn't export it the way I have to have it to import it into my other program. Here is the way it looks when Access exports it. ------------------------------------------------------------------------ | NCSSTATUS | ATDOOR | HOWMANY...

I have a form. On this form a user clicks a command button which runs a macro. The macro has an OutputTo action. For the "output format" I have tried both .rft and .txt. Neither one of these formats output the records to a comma delimited file. I have to import the records into another program...

I use a command button on a form to open a report. You can't see all the fields on the report because it always opens up in "portrait." Is there any way I can specify to open up the report in "landscape?"