Search results

http://www.mrexcel.com/forum/microsoft-access/549769-access-2003-how-see-linked-table-path.html Is this it?

Hi,. I tried to replicate your tables. Query 3 is a copy of your SQL statement and you can see the output. Are the tables I made the same as yours? The query returns 6 results, because I have 3 entries with identifier "1" in table2 and two in table3. Access will output all possible combinations...

Try renaming the identifier fields in all tables to HeatID. SELECT Table1.Diff, Table1.name, Table1.maxSignalTreadGate2dB, Table2.LTemp, Table3.Height, Table3.Weight FROM (Table1 LEFT JOIN Table3 ON Table1.HeatId = Table3.heatId) LEFT JOIN Table2 ON Table1.HeatId = Table2.HeatID GROUP BY...

Thanks, I never went into it when I looked at SQL produced by Access.It's just always there and I copied all :-).

You could create a query with the following SQL syntax: SELECT DISTINCT your_table.your_field FROM your_table WITH OWNERACCESS OPTION; and have the source for your combo box from that query.

= 0, not >0. Do you have those two numbers in one cell?

Hi, I'd include field SIDE ID to TABLE1 and TABLE2 and drop distance from TABLE2 or SITE MASTER. Than you can make joins on SITE ID between your tables and create query based on SITE ID and dates. Also, you'll find it much easier in the future if you don't use spaces in your field names and...

Hi, it seems that we finally made it :D. Below is the code that works, it is in standard module. Public Function GetWhereValue() Dim varwherevalue As String Dim strFormNames(1 To 2) As String Dim i As Integer strFormNames(1) = "frm_Brojcanik_IGT" strFormNames(2) = "frm_Brojcanik_Novomatic"...

Please bear with me :-). I copied your code like this to module1: Public Sub samo() Dim strFormNames(1 To 2) As String Dim i As Integer strFormNames(1) = "frm_Brojcanik_IGT" strFormNames(2) = "qry_Brojcanik_Novomatic" 'strFormNames(3) = "FormName3" '... and so on ... For i =...

Jmriddic, I'm toying with your table. One question about licensure/certification: is there a set of licenses that could aply to all eight licensures? Regards, Samo

Hi, yes, only one form will be open at the time (they will be modal) and yes, field names are the same on all the forms, text box "serijski". Data type is text, because those serials aren't all composed from numbers. At this moment there are six forms, but I'll add two more dummy forms if some...

Open your query in design view. You'll see under "table" that your query uses tables Contract Employees and Contract Employees_1. I think you copied your original table to create this one. As for multiple entries: I believe Access will give you one entry for every instance where ANY of the...

The problem is criteria for that query. How can I tell the query to take input for serial number from any of those six forms. I can't use forms!formname!textboxname because I don't know which form will be calling the query. If I understand correctly, I should somehow create a variable that will...

Sorry, I forgot that it isn't in English. serial is "serijski", manufacturer is "proizvodac", inventory numbers are "pit" and "broj", "igra" is game.

I haven't made the report yet, but that is not the problem. Once I get the query running from any of the forms, I'll just base the report on that query and pick the right report based on the manufacturer. Attached is the picture of my project, query1 should get the serial from either...

Hi guys, I have a form that displays information in a subform (manufacturer, serial number and inventory number) about slot machines that I need to repair. When I double-click on a machine, another form comes up, based on the manufacturer. I use those forms to input the counters for that slot...

llkhoutx, thanks for the tip about testing. Anyhow, I found out what I did wrong and it wasn't a query at all. In VBA that services the click event I had the part that writes some values to one table (vhat a user did to service the machine), then this: Forms!frm_Prikazi_Prijavljene_IA.Requery...

Hi, I have a problem with an update query. I have a table with a list of errors tbl_Prijave, where a user enters what is wrong with a slot machine, one field (Popravljeno) is set to "false" to indicate that it isn't fixed yet. There is a form with a checkbox where a user indicates that that...

Recyan, thank you. Works like a charm.

Hi all, I have a problem with a query. I have two tables, the first with customer ID's and contact data and related table with purchases for each customer. The second table has customer ID, date of purchase and amount.What I try to do is to display all the customers within given date range...