Recent content by sambrierley

Hi, a little background as to my request. I am building an equipment schedule for a project we are working on, the list will associate where necessary the equipment types. for example, cable X goes from point a to point b and powers these assets. this is informed from schematics as you would...

the front is used by users who do not directly interact with tables. the users load data (1000 records ish) via a macro which once imported is frequently moved between tables for various reasons before coming back together. when a table is changed, that change is reflected in the be which is...

Hi all, I've successfully split my database(be on server, fe on desktop) however the macros are now incredibly slow due to a lot of movement of data between tables. is it possible to restrict the syncing of tables? what would be good is if at the start of the macro i could stop syncing and...

Hi all, im trying to build my own custom search form that will basically loop through all the records until a match is found. i dont expect the user to know every bit of information so im allowing nulls by the use of "Or IsNull(Variant) = True" problem is i keep getting the invalid use of...

Hi all, thanks for any help on this. i have a form which contains a combobox. i used the query builder inside the combox box to build the row source which looks like the attached. what the query does is bring out the matching WSL for all Requirements.ID. is there a way so that the query uses...

Hi Plog, unfortunately no the tables are completely different, they are no way related. i understand what your getting at but unfortunately will not work. its looking as though simply automating clicking that button isnt possible.

ok... i have a userform that is attached to a table, standard stuff. as the user scrolls through the records sometimes a record will say "Refer to table X". what i currently do is this.. If InStr(Me.Heading_5, "Ref to table") > 0 Then TableName = Me.Requirement_Number & "_csv" 'this is the...

hi Ranman, thanks however that's not what i want to do, i want simply a piece that when triggers performs that action for the user and the results are the same.

hi all, i would of thought this was dead easy. can anyone provide the syntax for vba to create a userform with a variable as the source? i dont want anything fancy simply replicate opening a table and clicking the form button. thanks quick edit - p.s i can use this to create a form with...

Thanks this does work although doesnt look all that neat. For future readers a miles better looking option is to create the subform as instructed above. Then size it to be tiny and hide it somewhere. There is a function within the control property that allow filed from other table. this will...

Hi, should be a pretty simple solution for someone that knows what theyre doing :) I have 2 tables i've created a form based on Table 1. Table 1 and Table 2 have a relationship. i want to put a text box with data from Table 2 on the form. Structures. Table 1: [Doc ID], [Requirement], etc...

hi, thanks for the response. ive made the changes as you explained to no avail, i also tried the slightly different syntax of INSERT INTO [Export Table Dupes].field "INSERT INTO [Export Table Dupes]([Alpha Name],[Employee Number],[Work Date],[Account Number],[Explanation],[Sub- Ledger],[Pay...

hi all, im trying to insert into a table all records with the duplicates removed but im getting the above error. Str = "INSERT INTO [Export Table_Dupes]" & _ "SELECT DISTINCT [Alpha Name], [Employee Number], [Work Date], [Account Number], [Explanation], [Sub- Ledger], [Pay Code]...

hi all, I have 2 tables, the first is an inventory list and the second is a log file from an asset. Table 1 Lat, Long, Road Table 2 Lat, Long, Data I want to join the two to get this table Table 3 Lat, Long, Road, Data problem is the lats and longs dont match alot of the time. is there a way...

Hi all. im defining the below string to be used in an execute command from Project to add a calculated field to a table. Job Number is a variable (1086) and is the name of the table. the error im getting is "Syntax error in field definition" and seems to be related to the Duration field (the...