Search results

Hi, I'm trying to use the following code, however access is telling me that the user defined variable is not defined.. Now I'm assuming that I am missing a reference for this, however I've got all the ones I can think of selected.. Any ideas? Code in red is where the error is flagged Dim...

I have a database that is used for ETL processes, it has a simple gui that just links a few buttons to a bunch of code. It reads from another access database that contains all the tables, plus a few linked odbc tables. This all ran fine under access 2003, but it now runs dog slow, with no...

Hi all.. Long time no see.. I've got a form that sets a flag when opened, and taken away when you navigate away from the form. My issue is that if the form is open and you close Access, the flag is not reset.. This also occurs if my db crashes.. Is there a way to catch this?

Hi, I've just applied a password to my backend file, relinked the tables on the frontend thus applying the password. Everything works fine.. However, I seem to be unable to save a new .mde version of my FE. It says it does it, but no new file is created!?!?!? Anyone know how to fix this?

Hey. On a form, i have two subforms. One displays a list of user id's (listSubform), the the other displays a username (nameSubform).. What i'm trying to get to happen is when a id is clicked in listSubform, I want the corresponding name to be displayed in nameSubform.. This shouldn't be...

Hey, i'm trying to output a query i've built in code to a excel doc, but failing to get it to work.. Im trying to use the docmd.outputTo command. I've tried creating a querydef, but can't seem to get it to work.. Does anyone know how I can do this? Cheers

Hey guys, I've been working on Access for a little while now, and my job here is about to end soon (hired through a recruitment agency). After playing with databases for a while, i've grown to like it, and i'm contemplating furthering my knowledge in the area, thus I was wondering if people...

Hi, if I have a table field with a line of ID's like 323 OR 234 OR 12 OR 654 OR 1232 (memo field) How would I incorporate that into a WHERE clause of a query? I tried WHERE [userID] = [groupIDs] but that just confused access and the query wouldn't open or display the datasheet Cheers :)

I'm looking at moving my db to a SQL backend.. My db is already split, so i'm unsure what I have to do to point my frontend to the SQL backend.. I'm just going to start by testing with SQL Server Desktop edition.. Any help would be greatly appreciated..

I've got the following Select statement, but vba won't let me compile it with a ) on the end (as shown). Giving a "Expected: end of statement" error. But Access obviously throws an error if there are no ) Me.frm_Change_ApproversSubform.Form.RecordSource = "SELECT name FROM qry_getName WHERE...

Hi, I have a query which selects a group of people relevent to a department, and since the group is more of a, list of certain people, rather than defined by titles (i.e. the group is the manager, the accountant, the clerk), my query just manually uses the ID's of the people required. (WHERE...

For my database, various role names can change every now and then. In order to combat this, i'm thinking of creating a query for certain positions. What I mean is: Production Manager is a pivitol role, since it gets referenced to for approvals and placed in emails etc. If this title...

I've got a report that i'm trying to filter using two dates.. My form has two text fields that allow you to enter the dates, I then use the docmd.openReport Where clause to open the report based on the selected dates "(((tbl_Change.Date_Start) Between " & Me.frm_Reports_Date1 & " And " &...

Hey, I have a split database that multiple users will be accessing, and am looking at ways to maximise performance. I was wondering if somebody could tell me how often a query accesses the tables it is linked to. ** The following may be way off base and completely stupid, so if im going in...

Ok, this maybe a really stupid question.. Operating on a split database.. If I have a table with a bunch of values, say Department names for example. If I create a query and fill it with the contents of the Departments table, does references to that Departments query access the backend at...

Hello, I currently have a database thats working ok, however its not as efficient as it could be, and certain changes (which will be happening more often in the future) cause a lot of hassles, so i'm looking to redesign this certain area. I must admit my knowledge of table design and...

Hi, I was wondering, is it possible to disable the ability to hold shift when opening a .mde file?

Hi, I keep getting a write conflict message when i try and modify a record.. can someone explain to me why this occurs

I have a continuous form that has three text fields, one plain text (description), one date (date), and one another plain text (name). There is also a delete button.. When I click on the date text box, a calendar is opened, date selected and that is then inserted into the date text field. The...

Hey, I have a subform that displays a list of records and i'm trying to figure out how to delete one.. I've setup a delete button that deletes the record from the table, but that doesn't delete the record being shown in the subform, but simply replaces the values with #Deleted Cheers for...