Search results for query: *

I'm working with legacy Access DB, and the startup form maximizes every time. Is this something that Access does by default? How do I make it open the window to the size I want? Thanks. -Brad

Ever install a program and when you're done the folder where everything is installed pops up? How is that done?? Thanks! -Brad

I am using FileSystemObject to open, edit and create text files from VB. I have a couple questions: 1. Is there a way to find out how many lines are in the text file just opened? 2. Is this the best way to read/edit an ini file for my own application? 3. Is FileSystemObject the best way to...

I run a routine that interacts via DAO w/ Access database. When it's done, I want to open the database for the user to see. The only way I know how to do this is with ADO (e.g., Access.Application.OpenCurrentDatabase and .UserControl = True). Problem is... I get an error saying that the...

Hi. I am pulling some values from a .ini on load, and I want to put these values into an array that can be read by the rest of the project. But I guess you can't declare Public arrays in VB... Any thoughts on the best way to do this? Thanks as always. -Brad

Anyone know where/how Access stores import/export specifications from the Import/Export wizard? I am trying to bypass this process but having lots of trouble. If you have any other ideas, that would be great too. -Brad

I am using TransferText method in Visual Basic to import a text file into Access. I am giving the schema.ini file in the TransferText argument but I am getting an error that the file does not exist. Does anyone know what is going on? Thanks. -Brad

Is there a feature in VB that works like Access's subform? I am creating a "wizard" and I want to display a series of checkboxes on the left side of the screen that shows the user's progress. Of course, this (as well as the 'next', 'back' buttons, etc.) would be constant from form to...

I am trying to automate some boring tasks involving database maintenance at work -- this means programmatically creating (or copy/pasting) tables, forms, queries, reports, etc. I couldn't figure out how to create tables via automation -- is there a way to do this with ADO? And I couldn't...

Any thoughts on whether "linking" tables to a front-end access db using the access linking feature is less efficient than explicitly creating connections to the sqls7 backend?

Hi guys. I posted this on an Access forum, and I'm curious to see if I'll get different responses on this forum. Thanks in advance for your insight. -Brad --- There's a push at my company to change our internal data entry/storage system to an ASP/SQL-Server model. I have been very vocal about...

Any thoughts? There's a push at my company to change our internal data entry/storage system to an ASP/SQL-Server model. I have been very vocal about using Access as a front-end instead of ASP (SQL Server would backend nevertheless). We are using Access now (though not well) so employees...

Does anyone know how speed of methods in VBA compares to that of actions in macros? And could an experienced access programmer tell me how a well designed access application should generally look? In other words, are macros used a lot? Queries? Books on access generally have a lot to say about...

Anyone know how to set the view for a form? Sounds like a pretty simple task, but the only form properties that relate to views are 'default view' and 'views allowed.' i would like to keep the default view as datasheet for other purposes. Thanks in advance. -b Brad Figler...