Search results

Thanks guys, easy when you know how I'm sure, I'll keep it as a separate standalone DB and open it with vba. How much do you guys charge for building DB's haha :unsure:

Thanks for the info guys, sorry for the badly designed db.......this isn't my day job! I sent the DB as it was as it works like this, once split it doesn't work. I'll just put some vba to open the DB and keep it 'whole' rather than splitting it as it works like this

Yes the field is a table lookup field. Attached is copy of the db. Sorry for it not being a great example of a db!! :) When you open the DB and look at the frmRefitDraftSearch you will see in the subform a component name, everything works fine in the DB. When you split the DB and then look...

It is a short text field type that uses a lookup table. I have the same field type on the same table and this works fine Data is showing is in the query and table but not on the form.

Good Morning all, I have some really odd behaviour on a split database I have. I have just imported a database into an already large split database. Once imported the new parts of it work fine, no problems at all. I then put only the tables into a different location, deleted the tables in...

Thanks Pat, that makes sense. This DB will only have a few thousand rows at the very most, more likely less than one thousand so OpenForm method should work well

The qry sorts firstly by department and then secondly by a job number (this is auto generated by concatenating two fields together (a prefix and the autoID). This is good for how I want to present the data in another form, however in another form I want it to open to just show the last record...

Hi All, I have a button that opens another form, I want it to display the record with the highest ID (Autonumber). This worked fine using DoCmd.GoToRecord , , acLast However I have changed the sort in the qry the form gets its data from, as such now the ID's are not in numerical order so the...

Thank Pat, will take a look, make sense

I'm confused! Sorry! I have tblEquipment which has several fields such as model number, serial number, etc. One of the fields is an attachment field to attached documents and photos to (could be 3 or 4 attachments). I have a form (frmEquipment) to search this table via a query, it requery's...

Thanks very much, working. That example is appending from table to table all records, I've only ever used queries to filter records from a table, can I use a query instead of a table the INSERT INTO statement? Or is it better to use VBA to filter the records instead of a separate query?

HI DBguy, I've just seen this post and it is something I'm looking for, tried your example but it is coming up with a compile error, saying the code must be updated for 64bit system......How do I do this? Thanks in advance. Also whilst on the subject I have another related question you could...

Works great, thanks very much

Thank you very much, I'll try this later today/tonight, unfortunately don't have the time at the moment, I'll keep you posted. Thanks again

Yes I have a table called 'tblCurrency' which has all the currencies on, the actual expenses are on 'tblExpense' (Query2 takes the results from this table - so cash totals for this month) and the End of month ROBs are on a table called EOMCount, (Query1) I use a query to extract the latest (last...

Hi All, I need to make a query that will subtract the results from one query against the results of another, issue I have is that the results aren't equal.... Query1 (Last month cash ROB) Cur Amount EURO 500.00 USD 1000.00 GBP 50.00 Query2 (Cash used this month) Cur Amount...

OK thanks for this, agree better to have a popup form with the questions, thanks guys

Good Morning! I want to add a temporary field to a query that prompts the user for a yes or no answer. I can do this by putting something like " ILL: [Has person been ill] " in the query field, Only issue (and this is really first world problems! haha) is that the user has to type in Yes or...

OK no worries, wasn't sure if you could use VBA to make actions of another program to remove the manual part of printing to pdf.....is really only a minor thing and not to worry, thanks again

A nice to have would be if I can add some code to print to PDF the MailMerge document when it opens.....not the end of the world but if this is an easy thing to do your help would be much appreciated!