Search results

hi all, i'm tryin to use acc 2007 and i see that all has been hidden very well... ok - i want to be able to import a spreadsheet via a button. i imported a spreadsheet and saved the steps, but i see no code anywhere where this has been saved (?) i wanted to create a button and add the code...

would having a db with several tables and NOT setting any relationships up in the relationships window affect the db in any way? i have such a db, which originally had all the relationships set etc. however, as i encountered errors and had to replace tables and delete entries, i must have at...

I have a small access db in a network which has started to crap out far too often lately. The main table records job entries and inserts a date stamp. Every now and then, an entry has a ridicuous ID (auto inc field) and/or a bad date stamp and i can't delete the record (instead i have to output...

please delete this thread sorry all

Hi all, I have a single spreadsheet with multiple tabs, and I need to change that to multiple spreadsheets with a single worksheet each. I'm wondering if any of you have come across a little script or app that might do this?

Can I create a table 'on the fly' to host an xl import? I'm using... DoCmd.TransferSpreadsheet acImport, 8, "tbl_Import", sPathOfFileToImport, True ...at the moment, and it would be neat if I could tie it into that statement The issue is that I need to import an xl spreadsheet whose...

Hi all, I'm having trouble with my syntax in an SQL statement that passes variables I'm trying to do this: SELECT * FROM MyTable WHERE ID >= var1 AND < var2 I'm having probs with the single & double quotation marks that separate the vars from the statement proper I got something like this...

Don't display records older than x days - problem with syntax Hi all, I have a table with some records: Name, Date (Day/Month/Year) John, 09/09/2005 Phil, 10/09/2005 Xena, 03/11/2004 I want my query to display all records with today's date, or those that are 100 days older than today's date...

Hi all, I want to retrieve a set number of records from a table, using a query. I'm not sure of how to do this. I can't use the ID, because the table gets its data replaced contantly by imports (so the ID doesn;t start at 1...) I want to be able to retrieve, say, the first 25 records on that...

Using FileDialog(msoFileDialogOpen), how do I get the name of the selected file? I've worked my way down the properties (e.g: Debug.Print Application.FileDialog(msoFileDialogOpen).SelectedItems .Item .Title etc... Thanks in advance

I'm hoping somebody can help me with this: I want to create an array inside the loop to record 2 sets of data: a name, and a number. I don't know how many records the loop will run through, hence I need the array to be dynamic. If anybody can help me out with some code, I would be most...

I have a stored query in my db. The query gets the recordcount of all the items in a table. In my VBA, rather than code a new db conection, set a recordset etc, I want to execute the query using DoCmd ======= DoCmd.OpenQuery stDocName, acNormal, acEdit ======= The above line displays the...

Hi all, Can I set the default path for a dialog box to look in when called?

I'd like to display the contents of 2 fields in a single textbox. Any help is greatly apreciated :)

I need to duplicate a recordset in a table. How is this best done please? 1 set up a temp table, copy the recordset to the temp table and use an append query to re-added to the original table? or do it in code using recordset.clone? I'm not sure of how to do this using either method, so any...

Can I use the len function in a query's criteria field? I've tried a few things like: (len<4) [len<4] etc cheers for any help

Hi all, I want to build a form which displays a repeated (as in the data repeater) monthly view for a number of people. Each day is represented by a clickable button (or similar object) which then calls another form in it's click event. I'm not sure where to start, so I'm wondering if anybody...

I'm looking for some help on this one: I have a macro based on a query that returns all the entries created today: [Date_Created]=Date() This works fine on my machine (Win2k , svp 6, Office 2000, svp 2) but doesn't run on the machine I needed it to run on! (Win2k, office 2000 - unknown svp...

I want to set a textboxe's controlstyle to multirow, but I can't find this property in the control's property list, nr can I set it in code: MyTextBox.ControlStyle = MultiRow That just makes Access tell me to use the properties list Any help is appreciated :)

Hi peeps, hoping somebody can help me with this one: I have a PK field called ID. It's value is autonumber but I want to add to that the month and year eg: 41.02.04 42.02.04 43.02.04 Does anybody know how to go about this?