Search results

Hi no look ups in table i look up in the form and store that data from table two into table 1. but it only displays the ID (primary key) and not the second data of Text ID Text 1 Unknown 2 Deficit 3 Surplus its the text i want displayed in the query not the ID number which it...

I have query that comes from 1 table, however one of the fields gets its data from another table and stores the results (from a combo) in the field. The data from the second table has 2 data types, ID which is the primary number and 2 A text field on the query i want the text field to...

Thanks all sorted

I have a report that query based, it has 4 sets of dates. The reason for report is to seek incomplete actions But if the 4th date is present, the record/action is closed and does not need to appear on report. How is this achieved Thanks

I have a main Table that holds all core data that gets data from other tables. I need a query that returns the following data:- Site Manager = Site number, Site Name Each manager, manages a number of sites in the site manager table i have the following fields ID (PK) and Site manager This...

That makes sense, the problem with subforms (apart from the 1st tab for comments which would benefit from a subform as that is continuous and therefore not restricted to 7 or 8 max) sub forms dont display is the same way as they are currently laid out, So i guess my only other option is to have...

I've looked though this and I still cant work it out whats going on, sorry am a bit of a noob Keith

Please see attached

Ive checked both these and it still will not let me add at the form, any ideas

I know I've done something dumb, But I cant enter data directly on to the form I can enter data onto the table, and it appears on the form. What have I done wrong?? Thanks in advance

I am not using the query method, i am a bit of a noob so not sure how to use this method

This is fine but the problem is i dont want it to appear as a subform as I need a layout as there is a lot of information. The only way I could work out to solve the problem was to ensure each site number is on table 2 and every record in table 1 has data in table 2 eventually, i was just...

I have a form with a 3 page tab. 1st Tab Data comes from table 'Site Data' 2nd Tab from another table 'Fin Data' both tables are linked in a relationship by the 'site number' Tab/Table 1 has 12 records Tab/Table 2 has 1 record When I open the form instead of all 12 records showing its only...

thisa is Resolved Thanks

Okay but how do I keep the data fields on 1 tab only and not show on all

This is probably really basic, I have 3 tabs and want to display different data on each tab, but each set of data is showing on all 3 tabs how do I stop this Thanks

Private Sub cmdReport_Click() ' Check that the current record has a stock code. If IsNull(Me.[Stock Code]) Then MsgBox "Please activate a record with a valid stock code.", vbExclamation Exit Sub End If ' Save the record if it has been modified If Me.Dirty Then...

actually came up with =Nz(Sum([StockIn]),0)-Nz(Sum([StockOut]),0) for my total stock count and =-Sum(([Location]="1")*(Nz([StockIn],0)-Nz([StockOut],0))) for warehouse1 =-Sum(([Location]="2")*(Nz([StockIn],0)-Nz([StockOut],0))) for warehouse2 Works perfect Problem solved

Hi guys I want to create a report, and have a button on the form to print a report base on the form. But I only want it to print a report based on the form in view How do I do this, as at the moment when I print a report it prints all the reports Thanks

Hi Guys Another problem I need help sorting out. I have a stock control system that has tabs. On the 1st is a set of data that gets its information for else where, On another tab I have a stock activity sub form that gets its data from a table called stock activity. In the Sub form I have...