Search results

Hello, I've been tasked in the last few months by my bosses to make a database for a client who has requested our database to be different from anything we usually create and also to take out percentages from the underlying data. The client company also wants the source data (presumably to...

Hello, I'm trying to concatenate together all the ID fields from a table. However for some reason, my recordests are only picking up a single record meaning the loop cannot concatenate. i might be missing something simple for all i know my code : Dim dbs As Database Dim rst As...

Hello, This takes alot of different things into account but i'm thinking its the query itself that is the main problem. Apologese if i am mistaken and put this in the wrong place. I have a Pass through Query which is actioned when a button gets pushed on a form. Basically the functionality...

Is it possible to do this: http://msdn.microsoft.com/en-us/library/system.timezoneinfo.findsystemtimezonebyid.aspx in VBA? i'm pushed for time and struggling to get this done. i've seen many scripts to get information on your current time and everything but i need to get the date and time...

Hello, I've been creating a new database and the users have asked for unbound forms to be used. This means i'm passing variables into forms using DLookup and SQL strings. The one i'm currently on is a form which needs to check the table it would normally be referencing, see if a log exists...

Hello, my current place of occupation is wanting to split their current databases so there is a front and back end. Now obviously there are much better ways of doing this as i know. but the company is wanting to stick with access (presumably for financial reasons) we have successfully managed...

I've been given a theory to work with over this weekend in office 2003 i have a form with alot of fields. Its been a pain. its crashed the form etc etc basically all the field names in the form are the same as the table and what i was wondering if rather than having them all in a massive SQL...

i need a validation rule i have a field that needs to get the first three letters from another fields value + 8 numbers for example Product = Funtime Frank ShortCode = Fun12345678 the colours are just there to demonstrate what i mean this is my validation rule like Select Left...

i have a combobox with brings up 4 values. The combobox rowsourcetype is table/query. so for example say i have in this combo box values 1,2,3 and 4. I then have a pop up box saying 'is the record you want to create value 4?' If yes then type 4 successfully is slotted into the combobox, which...

i've been issued with a new problem now and i was wondering if you could help me. Firstly apologies if i am breaking any forum rules, or if this can be done without VBA. I've got a form. The form is a searcher. It uses 2 drop boxes and a set of radio buttons to pull up fields in a subform...

I'm pretty certain i did this in VB.Net in university, i know VB is a bit different but is it possible to populate an array using a loop?

is it possible to run 2 for loops alongside each other for example can you set one loop to loop through one array while another array is doing the same then compare the two like if array1val = arrayval2 then message box array is equal else message box array is not equal

Hello, i'm new to the forum and i've been working on this problem for the best part of a week. So far all was going well until i came to this issue. I've recently started a new job which involves using access 2003 and VBA and was given a few tasks to do, as follows find or create code that...