Search results

Dont think so - you're using a parameter that the user specifies. If you put it into a form then you could, because you could check the textbox first then proceed if it has a PO number. Vince

Hi, Assuming you are going to use ASP on the intra/extra/inter and any other net :) then it shouldn't take too long for an experienced vba coder to pick up the nuiances of Asp and html/css output. The hardest part is getting the data, validating it and returning it if its wrong without saving...

Or PM me ;) hehehe Ken's great though so he'll probably do it for you :) No Agencies please - resource for freelance jobs and for posting (I think you may have to register first ..... to post a role/project/job) Vince

From the sounds of it you have one huge table with loads of records.. and you have noticed that its better to break them up and hold them in separate tables, and have a linked main table to these tables. For each set/group of fields that you make into a look up tables (normalisation) you need a...

Use a frame then the options inside, assign each option a value different to the rest. Rename the frame fra<something> where <something> is more relevant to you. In VBA fraSomething is the value of the option selected. In design mode set a default value for the form. Also make sure that the...

Whats the code you are using? Is the form bound? Are you using ADO? (is there a status for the record, I know there is a recordset status...) Vince

Look up tables - each has a unique id field - Items - Units - Scheduled Checks Main table - uniqueid to refer to - ItemID - UnitID - Checked Date - Amount Then use queries to gather information into a format you want. Vince

Just another option.. VBA replace function and replace the single quote (') with the apostrophy (`) Vince

Whats the Sql statement? add another calced field in there? also isn't the iif meant to be iif([manorwoman]=1,0,[amount]*1.05) Vince

Log in as administrator (assume that you have your own administrator log in). Open the DB, and security>Permissions Select the users group Select the table in question (and possibly any queries/forms afterwards) Change the settings to allow anyone to read it, and edit it (as a test). Apply -> OK...

Assuming you can scan and get a code.... To store a record: User: click in text box (locked) and scan (code is put into the textbox) Packaged: click in text box (locked) and scan (code is put into the textbox) Button: Saves whats in the text boxes to a table. Another table of users used to...

too many spaces (probably) [est_id] = ([Forms]![frmWorksOrderComplete]![frmWOrderHead]![txtjob_estid]) Also, as an afterthought, is this a subform? You may need the subforms name and not the form name in there instead. Vince

1) you did it but it will probably give you dulicates. 2) as far as I know, you have to run two queries, both have to have linked tables so you can find all those that are in one and not in the other. You said Sage didn't have a pk set, but there is a unique record? Have a read up on Left...

For j = 1 To 3 Forms("frmMain").controls("label" & j).Caption = "Drop " & j Next Vince

1) have a read on: DAO - database.tabledefs ADOX - schemas (search online) 2) delete query (delete * from tablename) to empty the table then import all or update query from an imported table which does the above. or code to import Vince

ok. Create a new query Add in the table to be updated then the table with the data. Drag the Primary key/unique id field that matches them Double click on the black line and change to Everything from the first table and only those that match from the second. Change query type to update. Double...

you forgot the .movenext inside the loop? Also what happens if it doesn't match - inifinite loop? What are you trying to do here in the code? Vince

Use the debug breakpoint and check its running the code. You may need square brackets in the forms listing... Forms![forCustomerDetails2]![forSiteName!forContactsJ obTracking]!cboLocation.Requery No idea.. poss the repaint method. But make sure its actually running the code first. Sometimes...

Use a left join in the query (if you have yet to learn sql statements) its the black line connecting the two tables, double click and change it so it says everything from the first table and only those that match from the second. Vince

See this thread... same question. http://www.access-programmers.co.uk/forums/showthread.php?t=73074 Its to do with how you make the join... before you update.. Vince