Here is what I tried. WHAT ELSE HAVE I MISSED OR SHOULD HAVE TRIED? My situation: SQL/Server in another country - direct Internet connection unreliable, private line cost-prohibitive, line condition changes constantly (ping 180 to 500+) Access SQL/Server via VPN connection - very slow but clean/reliable Access ACCDB (ace) database in...
If you create a blank form in access 2007, is there a way to apply a style to that form. So that the blank form can then have the same style as the other already created forms thanks ...
i am new to access sql and i built a select statement that looks like this: SELECT [Lab Occurrence Form].[Practice Code], Count([Lab Occurrence Form].[1 0 Preanalytical (Before Testing)]) AS [CountOf1 0 Preanalytical (Before Testing)], [Lab Occurrence Form].[1 0 Preanalytical (Before Testing)] FROM [Lab Occurrence Form...
I'm connecting the access 2007 database from 5 different machines. (C#.Net) I'm having this error message: The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked ...
I am trying to create an access 2007 database that allows staff that already have ID numbers to make a transaction and also other guest users who do not have ID number make a transaction. What is the best way todo this in access? A transaction involves taking an item out of inventory. Therefore if one a user (staff or external) has an it...
I'm reading over this query, and I came upon a line where I don't understand heres the line [FETT List]![FETT Search] FETT List is a table FETT Search is a column in FETT List Can someone explain what the exclamation mark means? Thanks ...
Hello, I want a Access parameter query to ask an user for a value (a location in this case). When I type [Enter location] in the Criteria field it works fine: I get a dialog box (Enter Parameter Value) with a textbox and my text (Enter Location). So far, so good. This works (the result also). But now I want a dropdown/combobox (instead ...
I have an Access 2007 database where I have two tables, exp_cash and exp_cheque. Both are linked to exp_cat, where exp_cat contains categories list, and exp_cash and exp_cheque contain id, cat_id, exp_date, exp_amount, and exp_note. When I tried to combine them nothing appears in the result unless I remove the cat_name from my query. I...
Hi there, Is it possible to have multiple currency denominations in a field? I have a field that will have a currency value that will be either euro's or sterling dependent on whether or not the applicable record is in the currency zone. Is this possible in Access or will i need to have seperate fields for euro/sterling? Thanks in ad...
I have two tables: Person and Shift Person has as lookup field which is a one to many relationship with Shift. I would like to create a form in which a listbox displaying records from Person is filtered based on the selection of a combobox containing the records from Shift. in other words, i want to select "days" (value 1) in the comb...
I have an access application that has a form that allows the user to enter case notes. The main field of this form is tied to a SQL Server varchar(MAX) field in the source table. Since the users switched to Access 2007, their program keeps crashing when they are on the case notes form. As a possible solution to this problem, I would like...
I have created a module in access 2007 that will update linked tables, but I wanted to run this module from vb6. I have tried this code from Microsoft, but it didnt work. Sub AccessTest1() Dim A As Object Set A = CreateObject("Access.Application") A.Visible = False A.OpenCurrentDatabase (App.Path & "/Data...
Hey all i have 3 tables each as follow cash_credit Bank_Name-------in_date-------Com_Id---Amount America Bank 15/05/2010 1 200 HSBC 17/05/2010 3 500 Cheque_credit Bank_Name-----Cheque_Number-----in_date-------Com_Id---Amount America Bank 74835435-5435 15/05/2010 2 600 HSBC ...
How can I show a MS-Access listbox row highlighted? I'm using MS-Access 2007. I want the first row of a multiple-column listbox to be showed highlighted through VBA. I tried Me.LstSample.Selected(0) = True, but it doesn't work. The code: Private Sub LstStation_AfterUpdate() With Me.LstSample If IsNull(Me.LstStation) Then .R...
I want to get the percentage for downtime in sql view in ms access. sum of downtime per country divded by online_minutes to get the percentage for different countries. ...
What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to loop trough the rows and put the data into an Access table. I don't want a import by hand (Get External Data dialog) but by VBA. The user gets a Form with a Browse button and then points to a Excel file with a defined content/f...
Abstract: I'm using VB to recreate a query each time a user selects one of 3 options from a drop down menu, which appends the WHERE clause If they've selected anything from the combo boxes. I then am attempting to get the information displayed on the form to refresh thereby filtering what is displayed in the table based on user input. ...
Everytime I open my mdb copy to work on something, I get this little warning label that some somethings have been blocked....click this button to un block? anyway I can default that off? thanks justin ...
So I have a form that user's use for data entry, and on one form there is a text box there that is basically used. To enter notes. However, if the user hits i need the cursor to stay in that text box, and start a new line (uh....like word would)....but currently it is jumping to the next control (text box). So is there a simple proper...
So there are 8 categories that may be associated to each order, but not necessarily all of them. So i was going to build a list box that allowed the user to double click each of the category they wish to associate when they have an "Order Detail" form opened up (unbound form that has hidden text boxes with all needed ID numbers). I want...