Search results

well I've tried to modify Allen Browne's code for tblPlateChangeWaste (not shown in picture but same structure as"tblMaterialsSubstrate" with less fields but it throws up an error saying I am trying to create a duplicate entry... here's my code : 'Duplicate the related...

Hi, Really need a bit of help here as I am well stuck :( I am trying to run a duplicate function with duplicates all fields in the main forms and also on the subforms. I've read an excellent guide by Allen Browne here : http://allenbrowne.com/ser-57.html However, I believe my tables are a bit...

Well the client is manufacturing boxes that uses different Types of papers. These types are normally fixed values (there's around 15 types now). For each type would be Grammage costs(weight). Client wants to adjust each grammage cost manually. The next column then would be the £/tonne price(Set...

I am porting an Excel spreadsheet table into a database I am building in Access and have come across a rather tricky situation. My client has a table in the following format : As you can see, Type column are all fixed values. Weight column consists of normal user input values but Set Price has a...

Hi all, I am currently developing in MS Access 2010. I have used the Tab Control feature in my form which I find very helpful. My main form contains several comboboxes which the users filled in. Users then click on the tabs to display calculated values based on the values they've entered on...

Hi all, I've recently created a linked table to the company's Global Address List. However, when I access the Link Table manager is lists the directory as a local temp directory on my computer. I hazard a quess that this is just a temp directory created to dump the table retrieve from the...

Yeah, unfortunately that's what the client wants and they want it in a hurry. To be honest I've only discovered about this when I upgraded to Office2010. If I am not mistaken though, if I upgrade to MS SQL Server in the future the feature should still be supported?

Managed to find a workaround but took plenty of code :( Oh well.

Right, found a very helpful ELookup module which looks like what I want here : http://allenbrowne.com/ser-42.html However, I don't really understand how to use it. How would I store the values returned by this ELookup?

Hmm, I've managed to run a simple query and filer the results so it looks something like this now : Name---------------------------Deparment John Doe-----------------------Finance John Doe-----------------------Manangement The tabs in my tab controls are all names the same, ie "Finance"...

In my table I have a column called "Departments" which is set in Access 2010 to be a multiple value field. This works brilliantly on user input level as a smart drop down box which contains check boxes which allows users to select one or more values. However, the problem comes when I need to...

Hmmm, good idea but wondering if it will work in my case? What I have now is actually a drop down box showing 8 departments. A query will be run according to the selection from this combobox. It works well now as I can lock the combobox and select the value of the combobox to a department...

I currently have a combobox which displays 8 options. These options would be used to update the results in my listbox. I am wondering if it is possible to control what the combobox displays depending on users. For example for user 1 I want to display options 1,6 and 9. For user 2 I want to...

Tidying up code - Sub procedures I am creating a lot of custom procedures used only in one main form. Right now what I am doing in the VBA editor is Insert > New Procedure. Edit: tidied up post to make my question clearer This inserts a new private Sub Procedure at the bottom of the General...

Well I've found a solution although not a very elegant one :) I've posted code here in case someone wants to do this. The code can be modified to show past 2 weeks, next 2 weeks etc as well easily. ' For this code you put in a date in Text37 ' It will output first week day last week in Text 32...

Hi, Sorry to confuse you with the 5th May date. Basically I want to generate a report based on date range of "last week". To be more precise it's last working week. So basically Monday to Friday unless it's a holiday. I have a table which records all holidays which is used by another code to...

I am just wondering if there is a code to generate a date range of last week. For example if I run the code yesterday (5/5) it will return the date from : 25/5 and to : 29/5. Ideally by running this code it will return 2 values to 2 designated textboxes. Thank you.

Hmmm another problem I am afraid :( I have code which opens up a form according to the value bound to the first column of a listbox. There are basically 3 types of forms to open, 2 of them opens showing the correct record but one refuses to show anything. It opens an empty form. I've...

Bless you! That's it... had a rogue macro in the Detail section. I was checking the Event handler for Form but can't find anything :) Thank you!

I really don't know what is wrong so hopefully someone could shed a light on this issue. I have a main menu with users see after logging in through a login screen. This main menu is formatted as a dialog type without any Recordsource. The really strange thing is that if I click anywhere on the...